Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 6697.1229692741@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  ("Mark Wong" <markwkm@gmail.com>)
List pgsql-hackers
"Mark Wong" <markwkm@gmail.com> writes:
> On Mon, Dec 8, 2008 at 4:34 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> "Mark Wong" <markwkm@gmail.com> writes:
>>> On Tue, Dec 2, 2008 at 2:25 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>> Are any of the queries complicated enough to trigger GEQO planning?

> Sorry for the delay in responding, here's the queries and the number
> of tables in each:
> [ worst case is ]
> Q8:  8 (7 uniqie) + 1 temp table

Well, geqo_threshold is 12 by default, so that theory loses ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Latest version of Hot Standby patch
Next
From: Tom Lane
Date:
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1324)