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

From PFC
Subject Re: strategies for optimizing read on rather large tables
Date
Msg-id op.sruhbejjth1vuj@localhost
Whole thread Raw
In response to Re: strategies for optimizing read on rather large tables  (PFC <lists@boutiquenumerique.com>)
Responses Re: strategies for optimizing read on rather large tables
List 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.

pgsql-performance by date:

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