pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gerry Reno <greno@verizon.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: join on three tables is slow
Date: Tue, 11 Dec 2007 23:35:57 -0500
Message-ID: <11806.1197434157@sss.pgh.pa.us> (raw)
In-Reply-To: <475ED469.5080906@verizon.net>
References: <475C96EA.6090002@verizon.net>
	<475CC478.7010102@Sheeky.Biz>
	<475E111B.6060203@verizon.net>
	<162867790712102200m2144573bw7447e0eff6720d55@mail.gmail.com>
	<475E8F6A.4030004@verizon.net>
	<162867790712110655o2cf99bf1n9acf6b440d726440@mail.gmail.com>
	<475ED469.5080906@verizon.net>

Gerry Reno <greno@verizon.net> writes:
> Pavel Stehule wrote:
>> there is diference in agg position. Send, please, query and explain
>> analyze output.

[ explain analyze output ]

The rowcount estimates seem pretty far off, even for simple cases that
I'd expect it to get right, eg

>          ->  Seq Scan on res_partner_address a  (cost=0.00..88.40 
> rows=16 width=552) (actual time=0.851..16.131 rows=559 loops=1)
>                Filter: ((("type")::text = 'default'::text) OR ("type" IS 
> NULL))

Are the ANALYZE stats up to date for these tables?

What PG version is this, anyway?

			regards, tom lane

view thread (11+ messages)  latest in thread

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

copy link · copy postgr.es

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-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, greno@verizon.net
  Subject: Re: join on three tables is slow
  In-Reply-To: <11806.1197434157@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