Reputation
5,452
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
12 27
Newest
 Yearling
Impact
~204k people reached

  • 0 posts edited
  • 0 helpful flags
  • 147 votes cast
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
Apr
17
comment Where does the magic column “name” come from?
It would help to show the definition of site.
Mar
2
comment How to upgrade PostgreSQL minor releases without a dump/restore?
I didn't downvote anything.
Mar
2
answered How to upgrade PostgreSQL minor releases without a dump/restore?
Mar
1
comment How to upgrade PostgreSQL minor releases without a dump/restore?
Which part of "stop the database server, install the updated binaries, and restart the server" are you having problems with?
Feb
25
answered Get a list of databases that have a certain table