Re: [SQL] vacuum analyze slows sql query

2004-11-03 Thread Greg Stark
patrick ~ <[EMAIL PROTECTED]> writes: > I noticed that a freshly created db with freshly inserted data (from > a previous pg_dump) would result in quite fast results. However, > after running 'vacuum analyze' the very same query slowed down about > 1250x (Time: 1080688.921 ms vs Time: 864.522 ms

Re: [SQL] vacuum analyze slows sql query

2004-11-03 Thread patrick ~
On Wed, Nov 03, 2004 at 07:01:00AM -0500, Andrew Sullivan wrote: > On Tue, Nov 02, 2004 at 06:50:31PM -0800, patrick ~ wrote: > > We have a nightly "garbage collection" process that runs and > > purges any old data. After this process a 'vacuum analyze' > > is kicked off (regardless of whether or

Re: [SQL] vacuum analyze slows sql query

2004-11-03 Thread Andrew Sullivan
On Wed, Nov 03, 2004 at 10:31:33AM -0800, patrick ~ wrote: > Just to clarify, the sliggishness isn't only during the vacuum > period. There are more more serious issues during the vacuum, > but i am not touching on those. The sluggishness is persistant > throughout daily operations. Then I suspe

Re: [SQL] vacuum analyze slows sql query

2004-11-03 Thread Jim Buttafuoco
TECTED] Sent: Tue, 2 Nov 2004 18:50:31 -0800 (PST) Subject: [SQL] vacuum analyze slows sql query > Greetings pgsql-sql, > > I have a very strange problem. Our production database is a fair > sized db, structure wise, and quite huge data wise. We have a web/php > based UI for our c

Re: [SQL] vacuum analyze slows sql query

2004-11-03 Thread Andrew Sullivan
On Tue, Nov 02, 2004 at 06:50:31PM -0800, patrick ~ wrote: > We have a nightly "garbage collection" process that runs and purges > any old data. After this process a 'vacuum analyze' is kicked off > (regardless of whether or not any data was actually purged). > > At this point I should mention th

[SQL] vacuum analyze slows sql query

2004-11-02 Thread patrick ~
Greetings pgsql-sql, I have a very strange problem. Our production database is a fair sized db, structure wise, and quite huge data wise. We have a web/php based UI for our customer to manage the data in our application db. The customer complains that the UI is sluggish accessing certain pages a