gsiems

696 reputation

111

bio	website	localhost.localdomain
	location	Minnesota, USA
	age	92
visits	member for	1 year, 9 months
	seen	May 17 at 17:26
stats	profile views	27

Linux, perl, postgresql, oracle. Other tools as needed.

	696 reputation	bio	website	localhost.localdomain	visits	member for	1 year, 9 months
111 badges		location	Minnesota, USA		seen	May 17 at 17:26

summary answers questions tags badges favorites bounties reputation activity

65 Actions

suggestions reviews revisions comments badges posts accepts all

May 3	answered	Daily and Differential Backups
Apr 12	answered	Why are constraints applied in the database rather than the code?
Mar 20	comment	What is a good way to determine the performance I should expect from a PostgreSQL server? Juan-- Take a look at packtpub.com/postgresql-90-high-performance/book
Mar 19	answered	get account activity in postgresql
Mar 19	comment	Very slow DELETE in PostgreSQL, workaround? Are there indexes on the foreign key columns of the child tables? I haven't tested it with postgresql, but with some databases (cough oracle cough) that can make a huge difference.
Mar 14	comment	How do I remove duplicate records in a join table in PostgreSQL? @marcamillion -- tid == "tuple id", not sure what the c means.
Mar 14	comment	How do I remove duplicate records in a join table in PostgreSQL? ++ for the exists solution. Much better than my suggestion.
Mar 13	comment	How do I remove duplicate records in a join table in PostgreSQL? @marcamillion -- The documentation has a short blurb on ctids at postgresql.org/docs/current/static/ddl-system-columns.html
Mar 13	answered	How do I remove duplicate records in a join table in PostgreSQL?
Feb 26	answered	Display user-defined types and their details
Nov 16	accepted	Troubleshooting Postgresql spatial query failure. Next steps?
Nov 16	answered	Troubleshooting Postgresql spatial query failure. Next steps?
Nov 15	revised	Troubleshooting Postgresql spatial query failure. Next steps? Updated with resolution.
Oct 26	asked	Troubleshooting Postgresql spatial query failure. Next steps?
Sep 6	comment	PostgreSQL Database Migration Since plain pg_dump specifies the column names in the copy command and it is the destination database that has the added column then you shouldn't need to use the `--column-inserts` option, or an additional database either.
Sep 6	answered	How to list all views in SQL in PostgreSQL?
Aug 27	awarded	Yearling
Jul 17	answered	PostgreSQL Initial Database Size
Jun 21	comment	Freeing disk space after dropped database @Jmoney38 -- If I had to guess I'd say that the difference is to be found in the $PGDATA/pg_log and/or $PGDATA/pg_xlog directories. Log files are for the cluster and don't get truncated when you drop a database.
Jun 21	comment	Freeing disk space after dropped database @Jmoney38 -- That's why I recommended doing the "du -sh `ls`" on the $PGDATA directory both before and after doing the database add/drop as that should flag which other directories are growing leaps and bounds.