Re: Simple postgresql.conf wizard

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark Wong" <markwkm(at)gmail(dot)com>
Cc: "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simple postgresql.conf wizard
Date: 2008-12-09 00:34:48
Message-ID: 3768.1228782888@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Mark Wong" <markwkm(at)gmail(dot)com> writes:
> On Tue, Dec 2, 2008 at 2:25 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Are any of the queries complicated enough to trigger GEQO planning?

> Is there a debug option that we could use to see?

Well, you could set geqo=off and see if the behavior changes, but
it'd be easier just to count how many tables are in each query ...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message KaiGai Kohei 2008-12-09 01:26:34 Re: Updates of SE-PostgreSQL 8.4devel patches (r1268)
Previous Message Mark Wong 2008-12-09 00:06:03 Re: Simple postgresql.conf wizard