Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Optimize querry sql
- From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
- To: Stanislas de Larocque <dllstan(at)gmail(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Optimize querry sql
- Date: Mon, 17 Sep 2007 09:25:41 +0200
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)
- References:
- Optimize querry sql
- From: Stanislas de Larocque
- Re: Optimize querry sql
- From: hubert depesz lubaczewski
- Re: Optimize querry sql
- From: Stanislas de Larocque
- Optimize querry sql
- Prev by Date: Re: Optimize querry sql
- Next by Date: Re: Format interval as hours/minutes etc
- Previous by thread: Re: Optimize querry sql
- Next by thread: Format intervall as hours/minutes etc
- Indexes: