On Thu, Jul 10, 2008 at 3:45 AM, Suresh Borse <s(dot)borse(at)direction(dot)biz> wrote:
>> The view executes very faster for the first time.
>> When I execute the view again and again suddenly it gets slow or it gets
>> The view contains multi-table joins.
Uh, how many joins?
If you're exceeding geqo_threshold then you would get plans with a
random component to them. You might want to increase the threshold,
although planning time would probably go up.
Also, what PG version is this?
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Mikel Lindsaar||Date: 2008-07-11 02:02:01|
|Subject: Importing data - possible UTF8 import bug?|
|Previous:||From: Scott Marlowe||Date: 2008-07-10 15:47:29|
|Subject: Re: query optimization|