Re: Backwards index scan

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Backwards index scan
Date: 2006-06-06 19:21:04
Message-ID: 20060606192104.GN10018@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 06, 2006 at 12:27:33PM -0400, Carlos Oliva wrote:
> Thank for your response Alan. This indeed corrects the problem as long as
> we configure the database to enable_seqscan=false.

If you have to do that, something is still wrong. Do you have
accurate statistics? Is the planner mistaken about something?

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2006-06-06 20:40:49 Re: COLLATE
Previous Message Sergio Duran 2006-06-06 18:54:01 Trigger function to audit any kind of table