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 12:13:19
Message-ID: 20050604121319.GA25309@eo.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Sat, Jun 04, 2005 at 02:07:52PM +0200, PFC wrote:
> don't forget to mention all the index columns in the order by, or
> the planner won't use it.

of course.
i understand the concept. actually i find kind of ashamed i did not try
it before.
anyway - thanks for great tip.

depesz

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bernd Jagla 2005-06-04 13:30:57 Best hardware
Previous Message PFC 2005-06-04 12:07:52 Re: strategies for optimizing read on rather large tables