4,342 reputation
922
bio website petereisentraut.blogspot.com
location Pennsylvania
age 35
visits member for 3 years, 10 months
seen yesterday

PostgreSQL and Debian hacker, DBA at MeetMe


Oct
18
answered Should I invest the time to change the column type from CHAR(36) to UUID?
Oct
17
awarded  Nice Answer
Sep
30
awarded  Nice Answer
Sep
8
answered Is the mapping between PostgreSQL system tables and information_schema views documented?
Aug
31
answered What are the pro's and con's of using PostgreSQL vs MySQL for binary data?
Aug
18
comment PostgreSQL: Corrupt primary key, inconsistent table
You might want to look at the plan of the grouping query to check that it doesn't use the index.
Aug
2
awarded  postgresql
Aug
1
comment Index Generation in Postgres
The algorithms for sorting on disk and in memory are not the same, so they will use different amounts of memory. But it's actually more likely that the in-memory sort uses more memory. Still, the numbers that have been quoted are quite bizarre, so it's worth a try.
Jul
30
answered Index Generation in Postgres
Jul
30
comment Index Generation in Postgres
This doesn't apply to his case, because he is using pg_dump, which already creates the indexes after loading the data. It says so in the question.
Jul
2
comment Postgresql row-level encryption
Not that it would make a difference in this case, but you are linking to the PostgreSQL 8.0 documentation, which is more than 6 years old.
Jun
27
comment PostgreSQL: Disk space not released after TRUNCATE
It's conceivable that another backend process still has a file descriptor to the file open. If this happens again, I'd try terminating all other backend processes, just to see whether it makes a difference.
Jun
22
answered Is it possible to quickly create/restore database snapshots with PostgreSQL?
Jun
20
answered PostgreSQL on Ubuntu - Using conf files for recovery
Jun
16
answered Source several files at once with psql
Apr
28
answered How to hide metadata from Postgres users?
Apr
27
answered Postgres 8.4 — connection refused (remote)
Apr
26
answered What are the differences between “Stored Procedures” and “Stored Functions”?
Apr
19
awarded  Enlightened
Apr
19
awarded  Nice Answer