From: David Shadovitz <david@shadovitz.com>
To: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Query plan - now what?
Date: Fri, 12 Dec 2003 07:46:36 -0800
Message-ID: <01C3C084.156718C0.david@shadovitz.com> (raw)
> This is not very informative when you didn't show us the query nor
> the table schemas..
> BTW, what did you do with this, print and OCR it?
Tom,
I work in a classified environment, so I had to sanitize the query plan, print
it, and OCR it. I spent a lot of time fixing typos, but I guess at midnight my
eyes missed some. This hassle is why I posted neither the query nor the
schema. The database is normalized, though, but my use of animal names of
couse masks this.
If you think that you or anyone else would invest the time, I could post more
info.
I will also try Shridhar's suggestions on statistics_target and
enable_hash_join.
Thanks.
-David
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: david@shadovitz.com, tgl@sss.pgh.pa.us
Subject: Re: Query plan - now what?
In-Reply-To: <01C3C084.156718C0.david@shadovitz.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