Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence Scan vs. Index scan - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Sequence Scan vs. Index scan
Date
Msg-id 20060322121333.GB27640@uio.no
Whole thread Raw
In response to Re: Sequence Scan vs. Index scan  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
Responses Re: Sequence Scan vs. Index scan
List pgsql-performance
Tree view 
On Wed, Mar 22, 2006 at 08:50:20AM -0300, Alejandro D. Burne wrote:
> Explains:
> ------------
> With SET ENABLE_SEQSCAN TO ON;
> HashAggregate  (cost=251306.99..251627.36 rows=11650 width=78)

You'll need to post EXPLAIN ANALYZE results, not just EXPLAIN.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Alejandro D. Burne"
Date:
Subject: Re: Sequence Scan vs. Index scan
Next
From: "Alejandro D. Burne"
Date:
Subject: Re: Sequence Scan vs. Index scan