Re: TB-sized databases

From: Decibel! <decibel(at)decibel(dot)org>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TB-sized databases
Date: 2007-12-06 00:07:58
Message-ID: 7C49F3E2-DD15-4C3A-879C-956B7504F257@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Cave-Ayland 2007-12-06 07:25:12 Re: Evaluation of PG performance vs MSDE/MSSQL 2000 (not 2005)
Previous Message Decibel! 2007-12-05 23:55:12 Re: autovacuum: recommended?