, March 21, 2006 3:08 PM
Subject: [PERFORM] Sequence Scan vs. Index scan Hi guys, I'm trying to figure out when Sequence Scan is better than Index Scan. I just want to know this because I disabled the sequence scan in postgresql
and receive a better result. :) Two tables. Table 1 (1 million rows
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:
2006/3/22, Steinar H. Gunderson [EMAIL PROTECTED]:
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./*
Hi guys,
I'm trying to figure out when Sequence Scan is better than Index Scan. I
just want to know this because I disabled the sequence scan in
postgresql and receive a better result. :)
Two tables.
Table 1 (1 million rows )
---
id
text
table2_id
Table 2 (300 thousand rows)
On Tue, Mar 21, 2006 at 03:08:07PM -0300, Fernando Lujan wrote:
I'm trying to figure out when Sequence Scan is better than Index Scan. I
just want to know this because I disabled the sequence scan in
postgresql and receive a better result. :)
That is a very broad question, and you're
PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Fernando
Lujan
Sent: den 21 mars 2006 19:08
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Sequence Scan vs. Index scan
Hi guys,
I'm trying to figure out when Sequence Scan is better than Index Scan. I
just want to know this because I
Subject: [PERFORM] Sequence Scan vs. Index scan
Hi guys,
I'm trying to figure out when Sequence Scan is better than Index Scan. I
just want to know this because I disabled the sequence scan in postgresql
and receive a better result. :)
Two tables.
Table 1 (1 million rows )
---
id