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

Re: query optimization

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: s(dot)borse(at)direction(dot)biz, "Julius Tuskenis" <julius(at)nsoft(dot)lt>, pgsql-admin(at)postgresql(dot)org
Subject: Re: query optimization
Date: 2008-07-10 16:21:44
Message-ID: 9895.1215706904@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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
>> hang.
>> 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 LindsaarDate: 2008-07-11 02:02:01
Subject: Importing data - possible UTF8 import bug?
Previous:From: Scott MarloweDate: 2008-07-10 15:47:29
Subject: Re: query optimization

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