Re: strategies for optimizing read on rather large tables

From: hubert lubaczewski <hubert(dot)lubaczewski(at)eo(dot)pl>
To: PFC <lists(at)boutiquenumerique(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strategies for optimizing read on rather large tables
Date: 2005-06-04 11:41:32
Message-ID: 20050604114132.GB21031@eo.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-06-04 12:07:52 Re: strategies for optimizing read on rather large tables
Previous Message hubert lubaczewski 2005-06-04 11:40:23 Re: strategies for optimizing read on rather large tables