Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve Postgres Query Speed - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Improve Postgres Query Speed
Date
Msg-id 1168976529.9586.11.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Improve Postgres Query Speed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Mon, 2007-01-15 at 23:26, Tom Lane wrote:
> "carter ck" <carterck32@hotmail.com> writes:
> > And you are definitely right when updating the table. The time it takes is
> > getting longer and longer. When I do a select statement, the speed has also
> > degraded.
>
> Seems like you need a VACUUM in there somewhere...

If he hasn't been vacuuming up until now, he'll need a vacuum full.

then regular vacuums.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: trigger howto question
Next
From: "Chad Wagner"
Date:
Subject: Re: Temp Table Within PLPGSQL Function - Something Awry