Re: Indexscan is only used if we use "limit n"

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org, sebaioni-postgresql(at)yahoo(dot)com(dot)ar
Subject: Re: Indexscan is only used if we use "limit n"
Date: 2007-08-16 23:10:53
Message-ID: 200708161610.53608.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2007-08-17 01:12:49 Re: Integrated perc 5/i
Previous Message Decibel! 2007-08-16 22:41:00 Re: Integrated perc 5/i