Re: strategies for optimizing read on rather large tables - Mailing list pgsql-performance

From hubert lubaczewski
Subject Re: strategies for optimizing read on rather large tables
Date
Msg-id 20050604114132.GB21031@eo.pl
Whole thread Raw
In response to Re: strategies for optimizing read on rather large tables  (PFC <lists@boutiquenumerique.com>)
List pgsql-performance
On Sat, Jun 04, 2005 at 01:18:04PM +0200, PFC wrote:
> Then write your query as :
> select advert_id from acr_cache where category_id = ? and region_id = ?
> order by category_id, region_id, XXX limit 20;

this is great idea - i'll check it out definitelly.

depesz

Attachment

pgsql-performance by date:

Previous
From: hubert lubaczewski
Date:
Subject: Re: strategies for optimizing read on rather large tables
Next
From: PFC
Date:
Subject: Re: strategies for optimizing read on rather large tables