On 10 May 2002 at 19:18, Brian McCane wrote: > But, a 4% decrease in size should not add up to a 84% increase in > performance (is that right? I always get the ratio confused :).
Have you tried an ANALYZE as well? It wasn't mentioned. See http://www.postgresql.org/idocs/index.php?routine-vacuuming.html PostgreSQL's VACUUM command must be run on a regular basis for several reasons: 1. To recover disk space occupied by updated or deleted rows. 2. To update data statistics used by the PostgreSQL query planner. 3. To protect against loss of very old data due to transaction ID wraparound. Read 8.2.2. Updating planner statistics -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
