162 reputation
19
bio website
location Vienna, Austria
age 94
visits member for 2 years, 9 months
seen Jun 4 at 22:44

Mar
1
awarded  Excavator
Mar
1
revised Can postgres internal log rotation mechanism delete log files older than a certain time?
typo & it's better to link to the /current version of the manual when not targeting a specific version.
Mar
1
suggested suggested edit on Can postgres internal log rotation mechanism delete log files older than a certain time?
May
20
awarded  Constituent
May
20
awarded  Caucus
Nov
26
awarded  Critic
Jun
5
comment PostgreSQL: performance descrease due to index bloatper
Are you serious about version 8.1 or is that a typo? For 8.1 I have quite an obvious idea what you should do: upgrade to a more recent version, preferably the current version 9.1. 8.1 has reached end of live in 2010, there have been countless improvements.
Feb
24
answered Grant password-less permission for specific script as specific user with sudo
Feb
24
awarded  Student
Feb
24
revised Grant password-less permission for specific script as specific user with sudo
loose end
Feb
24
asked Grant password-less permission for specific script as specific user with sudo
Nov
20
awarded  Teacher
Nov
17
awarded  Editor
Nov
17
revised PostgreSQL can't connect from python/psycopg
trim noise
Nov
15
answered PostgreSQL can't connect from python/psycopg
Oct
19
awarded  Supporter
Oct
19
awarded  Analytical
Oct
19
awarded  Autobiographer
Sep
21
comment Get back the Disk space from Postgresql
In that case you might consider CLUSTER instead, followed by ANALYZE. Optimizes best and all indexes as well. You could chose an index for that which sorts data according to typical queries - another benefit on the side.