Re: Sorting a query on a view ignores an index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mathieu De Zutter <mathieu(at)dezutter(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sorting a query on a view ignores an index
Date: 2003-08-21 17:02:08
Message-ID: 14117.1061485328@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mathieu De Zutter <mathieu(at)dezutter(dot)org> writes:
> Apart from avoiding views or subselects when sorting afterwards and
> putting the whole bunch in a huge SQL statement (which i'll have to
> produce on-the-fly), do you have an other alternative?

See if you can avoid the subselects in the view's SELECT list. That's
what's preventing 7.3 from doing a good job.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomka Gergely 2003-08-21 17:55:18 Re: Tests
Previous Message Bill Moran 2003-08-21 16:27:41 Re: Tests