Re: Optimize querry sql - Mailing list pgsql-sql

From hubert depesz lubaczewski
Subject Re: Optimize querry sql
Date
Msg-id 20070917072541.GA13991@depesz.com
Whole thread Raw
In response to Re: Optimize querry sql  ("Stanislas de Larocque" <dllstan@gmail.com>)
List pgsql-sql
On Mon, Sep 17, 2007 at 09:17:58AM +0200, Stanislas de Larocque wrote:
> Have you advices to optimize the query please ?

for some many rows the 400ms looks quite reasonable.

the best thing you can make to speed things up is to calculate the
counts with triggers.

depesz

-- 
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)


pgsql-sql by date:

Previous
From: "Stanislas de Larocque"
Date:
Subject: Re: Optimize querry sql
Next
From: Oliver Elphick
Date:
Subject: Re: Format interval as hours/minutes etc