Re: [PERFORM] Sequence Scan vs. Index scan

2006-03-22 Thread Alejandro D. Burne
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 AN

Re: [PERFORM] Sequence Scan vs. Index scan

2006-03-22 Thread Alejandro D. Burne
2006/3/21, Reimer <[EMAIL PROTECTED]>: Fernando,If you need to read all the table for example it would be better to readonly the data pages instead of read data and index pages.Reimer- Original Message -From: "Fernando Lujan" < [EMAIL PROTECTED]>To: Sent: T