pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: david@shadovitz.com <david@shadovitz.com>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: Re: Query plan - now what?
Date: Fri, 12 Dec 2003 11:52:56 -0500
Message-ID: <20394.1071247976@sss.pgh.pa.us> (raw)
In-Reply-To: <01C3C084.156718C0.david@shadovitz.com>
References: <01C3C084.156718C0.david@shadovitz.com>

David Shadovitz <david@shadovitz.com> writes:
> If you think that you or anyone else would invest the time, I could post more
> info.

I doubt you will get any useful help if you don't post more info.

> I will also try Shridhar's suggestions on statistics_target and 
> enable_hash_join.

It seemed to me that the row estimates were not so far off that I would
call it a statistical failure; you can try increasing the stats target
but I'm not hopeful about that.  My guess is that you will have to look
to revising either the query or the whole database structure (ie,
merging tables).  We'll need the info I asked for before we can make
any recommendations, though.

			regards, tom lane



view thread (6+ messages)  latest in thread

Message-ID: <20394.1071247976@sss.pgh.pa.us>
Permalink:  ../20394.1071247976@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/20394.1071247976@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, david@shadovitz.com
  Subject: Re: Query plan - now what?
  In-Reply-To: <20394.1071247976@sss.pgh.pa.us>

* 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