From: Tim Jones <TJones@optio.com>
To: Matthew O'Connor <matthew@zeut.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: strange query behavior
Date: Wed, 13 Dec 2006 17:54:06 -0500
Message-ID: <47668A1334CDBF46927C1A0DFEB223D39F7AB0@mail.optiosoftware.com> (raw)
In-Reply-To: <458083E9.8000908@zeut.net>
References: <47668A1334CDBF46927C1A0DFEB223D39F79A5@mail.optiosoftware.com>
<10648.1166037392@sss.pgh.pa.us>
<47668A1334CDBF46927C1A0DFEB223D39F79FA@mail.optiosoftware.com>
<12115.1166047135@sss.pgh.pa.us>
<47668A1334CDBF46927C1A0DFEB223D39F7A98@mail.optiosoftware.com>
<12548.1166049409@sss.pgh.pa.us>
<47668A1334CDBF46927C1A0DFEB223D39F7AAC@mail.optiosoftware.com>
<458083E9.8000908@zeut.net>
That's what I did and got 8.1.2 ... do you want gcc version etc 3.3.2
powerpc aix5.2
Tim Jones
Healthcare Project Manager
Optio Software, Inc.
(770) 576-3555
-----Original Message-----
From: Matthew O'Connor [mailto:matthew@zeut.net]
Sent: Wednesday, December 13, 2006 5:51 PM
To: Tim Jones
Subject: Re: [PERFORM] strange query behavior
From psql perform: select version();
and send us that output.
Tim Jones wrote:
> Looks like 8.1.2
>
> Tim Jones
> Healthcare Project Manager
> Optio Software, Inc.
> (770) 576-3555
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, December 13, 2006 5:37 PM
> To: Tim Jones
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] strange query behavior
>
> "Tim Jones" <TJones@optio.com> writes:
>>> Which PG version is this exactly? Are you running with any
>>> nondefault planner parameters?
>
>> Version 8.1
>
> 8.1.what?
>
>> Here are the planner constraints I believe we changed
>> effective_cache_size and random_page_cost
>
> Those look reasonably harmless.
>
> My best bet at the moment is that you've got a pretty early 8.1.x
> release and are hitting one of the planner bugs that we fixed earlier
> this year. Not enough info to say for sure though.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: TJones@optio.com, matthew@zeut.net
Subject: Re: strange query behavior
In-Reply-To: <47668A1334CDBF46927C1A0DFEB223D39F7AB0@mail.optiosoftware.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox