pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (6+ messages)  latest in thread

Message-ID: <01C3C084.156718C0.david@shadovitz.com>
Permalink:  ../01C3C084.156718C0.david@shadovitz.com/
Also on:    postgresql.org/message-id/01C3C084.156718C0.david@shadovitz.com

 · 

reply

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