On Fri, Sep 28, 2001 at 10:25:13AM -0600, Steve Wolfe wrote:
> > There is a user specifieable value somewhere that controls how expensive
> > index scan is and how expensive a seqential scan is. By tuning those you
> > could probably get the effect you want.
> Hmmm.... nice. Can anybody point me to that value?
In the documentation, section 3.4.1 here.
PostgreSQL 7.1.3 Administrator's Guide > Server Runtime Environment >
Planner and Optimizer Tuning
There's a whole bunch of tunable variables. It does say that there is not
much idea of what values are good so any experiments would be helpful.
Martijn van Oosterhout <kleptog(at)svana(dot)org>
> Magnetism, electricity and motion are like a three-for-two special offer:
> if you have two of them, the third one comes free.
In response to
pgsql-general by date
|Next:||From: Dinesh Parikh||Date: 2001-09-29 12:22:03|
|Subject: Re: Dynamic Query problem|
|Previous:||From: Tod McQuillin||Date: 2001-09-29 08:07:49|
|Subject: Re: Recreating unique index for primary key|