From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
To: sebaioni-postgresql@yahoo.com.ar
Subject: Re: Indexscan is only used if we use "limit n"
Date: Thu, 16 Aug 2007 16:10:53 -0700
Message-ID: <200708161610.53608.josh@agliodbs.com> (raw)
In-Reply-To: <377451.48008.qm@web36104.mail.mud.yahoo.com>
References: <377451.48008.qm@web36104.mail.mud.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com, sebaioni-postgresql@yahoo.com.ar
Subject: Re: Indexscan is only used if we use "limit n"
In-Reply-To: <200708161610.53608.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox