Request a Demo
Home   >   mailing lists

Re: Indexscan is only used if we use "limit n" - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Indexscan is only used if we use "limit n"
Date
Msg-id 200708161610.53608.josh@agliodbs.com
Whole thread Raw
In response to Indexscan is only used if we use "limit n"  (Sebastián Baioni <sebaioni-postgresql@yahoo.com.ar>)
List pgsql-performance
Tree view 
Sebastian,

> Whe are running PostgreSQL 8.2.0 on amd64-portbld-freebsd6.2, compiled
> by GCC cc (GCC) 3.4.6 [FreeBSD] 20060305. The query only uses the index
> if we have a "limit n":

Um, why are you running an unpatched version of 8.2?  You should be runing
8.2.4.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

pgsql-performance by date:

Previous
From: Decibel!
Date:
Subject: Re: Integrated perc 5/i
Next
From: "Luke Lonergan"
Date:
Subject: Re: Integrated perc 5/i