Re: intersect performance (PG 7.1.3 vs 7.2)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: d_nardini(at)btconnect(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: intersect performance (PG 7.1.3 vs 7.2)
Date: 2002-04-06 15:45:35
Message-ID: 25651.1018107935@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

d_nardini(at)btconnect(dot)com writes:
> Following are EXPLAIN dumps from each platform for both intersect and
> union (both return the correct data on each platform).

Did you ever VACUUM ANALYZE these tables on the 7.1 box? The statistics
estimates from that machine look suspiciously like default values.

If you did, then maybe I can credit 7.2's improved statistics machinery
with a win ;-). But I bet the better choice of plan on the 7.2 box is
due simply to having any stats at all.

Can't help you with the RPM dependency issues, sorry.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Joerdens 2002-04-07 14:15:19 Re: Rule trouble (looks to me exactly like the example)
Previous Message d_nardini 2002-04-06 09:49:16 Re: intersect performance (PG 7.1.3 vs 7.2)