Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Improve Postgres Query Speed
Date
Msg-id 15371.1168925165@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improve Postgres Query Speed  ("carter ck" <carterck32@hotmail.com>)
Responses Re: Improve Postgres Query Speed  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view 
"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...

            regards, tom lane

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Reserve a value in a serial type field
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Checkpoint request failed on version 8.2.1.