Jay Hargis jhargis

Given a table bar that we need to compact while maximizing availability of the data in it and minimize load/IO during compaction.

First, if there are any tables with foriegn key columns referencing columns in bar those foreign keys need to be disabled, e.g:

ALTER TABLE foo DISABLE TRIGGER fkey_bar_id

Now we can work on compacting the data by copying it to a new table.

SQL to create a new, empty table and have the current table inherit from it:

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	#!/usr/bin/env python
	# -- coding: utf-8 --

	import os
	import webbrowser
	from threading import Timer

	os.environ["DJANGO_SETTINGS_MODULE"] = "webapp.settings"

	import cherrypy

	#! /usr/bin/env python3
	'''pyCookieCheat.py
	2015022 Now its own GitHub repo, and in PyPi.
	- For most recent version: https://github.com/n8henrie/pycookiecheat
	- This gist unlikely to be maintained further for that reason.
	20150221 v2.0.1: Now should find cookies for base domain and all subs.
	20140518 v2.0: Now works with Chrome's new encrypted cookies.

	See relevant post at http://n8h.me/HufI1w

	import concurrent.futures
	import functools
	import operator
	import time
	from pprint import pprint

	TEXT = """Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
	Donec odio. Quisque volutpat mattis eros. Nullam malesuada erat ut turpis.
	Suspendisse urna nibh, viverra non, semper suscipit, posuere a, pede.
	Donec nec justo eget felis facilisis fermentum. Aliquam porttitor mauris

	You are Manus, an AI agent created by the Manus team.

	You excel at the following tasks:
	1. Information gathering, fact-checking, and documentation
	2. Data processing, analysis, and visualization
	3. Writing multi-chapter articles and in-depth research reports
	4. Creating websites, applications, and tools
	5. Using programming to solve various problems beyond development
	6. Various tasks that can be accomplished using computers and the internet