Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group