Re: TODO item - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: TODO item
Date
Msg-id Pine.LNX.4.30.0107042329280.679-100000@peter.localdomain
Whole thread Raw
In response to TODO item  (Martín Marqués <martin@bugs.unl.edu.ar>)
Responses Re: TODO item  (Martín Marqués <martin@bugs.unl.edu.ar>)
List pgsql-general
Martín Marqués writes:

> The other is related to indexes on databases other then initiated with C
> locale. The docs say that those databases don't use the indexes on sequencial
> searches. Is this right?

The database never uses indexes on sequential searches, by definition.
You must be talking about the LIKE optimization issue.  That is very hard
to fix, in my estimate.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Ryan Mahoney
Date:
Subject: pgsql and sql-relay
Next
From: Martín Marqués
Date:
Subject: Re: TODO item