Skip site navigation (1) Skip section navigation (2)

Re: sloooow query

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: marie(dot)tuite(at)edisonaffiliates(dot)com
Cc: josh(at)agliodbs(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: sloooow query
Date: 2002-10-07 20:52:16
Message-ID: 1034023937.3539.104.camel@camel (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
On Mon, 2002-10-07 at 16:34, Marie G. Tuite wrote:
> > What happens if you run VACUUM FULL VERBOSE on the Bad database?  Does it
> > report lots of rows taken up?
> 
> I ran the vacuum for selected tables.  It looks fine, I think, but I amn't
> always sure what I am reading in output.
> 

Is this vacuum being done on a system that is currently running slow, or
was this system recently dropped/reloaded?

Robert Treat



In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2002-10-07 20:57:40
Subject: Re: sloooow query
Previous:From: Robert TreatDate: 2002-10-07 20:50:27
Subject: Re: sloooow query

pgsql-general by date

Next:From: Tom LaneDate: 2002-10-07 20:57:40
Subject: Re: sloooow query
Previous:From: Robert TreatDate: 2002-10-07 20:50:27
Subject: Re: sloooow query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group