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 EXP
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.se
mance@postgresql.org>Sent: Tuesday, 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 receiv
ERFORM] 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
text
ta
al Message-
From: [EMAIL 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 wa
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 intro
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)
---
