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

Re: TB-sized databases

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TB-sized databases
Date: 2007-11-28 14:03:44
Message-ID: 1196258624.31315.9.camel@PCD12478 (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 2007-11-28 at 08:54 -0500, Bill Moran wrote:
> > Nothing wrong with enable_seqscan = off except it is all or nothing type
> > of thing...
> 
> If that's true, then I have a bug report to file:
[snip]
> It looks to me to be session-alterable.

I didn't mean that it can't be set per session, I meant that it is not
fine grained enough to select the affected table but it affects _all_
tables in a query... and big tables are rarely alone in a query.

Cheers,
Csaba.



In response to

pgsql-performance by date

Next:From: Pablo AlcarazDate: 2007-11-28 14:15:11
Subject: Re: TB-sized databases
Previous:From: Bill MoranDate: 2007-11-28 13:59:35
Subject: Re: TB-sized databases

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