Re: TB-sized databases - Mailing list pgsql-performance

From Decibel!
Subject Re: TB-sized databases
Date
Msg-id 7C49F3E2-DD15-4C3A-879C-956B7504F257@decibel.org
Whole thread Raw
In response to Re: TB-sized databases  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
On Nov 28, 2007, at 7:27 AM, Bill Moran wrote:
> Is there something wrong with:
> set enable_seqscan = off


Note that in cases of very heavy skew, that won't work. It only adds
10M to the cost estimate for a seqscan, and it's definitely possible
to have an index scan that looks even more expensive.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Attachment

pgsql-performance by date:

Previous
From: Decibel!
Date:
Subject: Re: autovacuum: recommended?
Next
From: Mark Cave-Ayland
Date:
Subject: Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)