Re: Improve Postgres Query Speed

From: Chris <dmagick(at)gmail(dot)com>
To: carter ck <carterck32(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Improve Postgres Query Speed
Date: 2007-01-16 04:19:11
Message-ID: 45AC523F.1080907@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-01-16 05:00:23 Re: Reserve a value in a serial type field
Previous Message Michael Glaesemann 2007-01-16 03:08:19 Re: Collating Question...