Re: strategies for optimizing read on rather large tables

From: PFC <lists(at)boutiquenumerique(dot)com>
To: hubert(dot)lubaczewski(at)eo(dot)pl
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strategies for optimizing read on rather large tables
Date: 2005-06-04 12:07:52
Message-ID: op.sruhbejjth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>> select advert_id from acr_cache where category_id = ? and region_id = ?
>> order by category_id, region_id, XXX limit 20;

don't forget to mention all the index columns in the order by, or the
planner won't use it.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message hubert lubaczewski 2005-06-04 12:13:19 Re: strategies for optimizing read on rather large tables
Previous Message hubert lubaczewski 2005-06-04 11:41:32 Re: strategies for optimizing read on rather large tables