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

From Chris
Subject Re: Improve Postgres Query Speed
Date
Msg-id 45AC523F.1080907@gmail.com
Whole thread Raw
In response to Re: Improve Postgres Query Speed  ("carter ck" <carterck32@hotmail.com>)
List pgsql-general
carter ck wrote:
>
> Hi, the rpt_generated is a boolean value.
>
> 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.

If you send us the query that is slow, then I'm sure you'll get some
suggestions about how to speed it up.

Have you run 'analyze' on the table?

--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Collating Question...
Next
From: "A. Kretschmer"
Date:
Subject: Re: Reserve a value in a serial type field