Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3
Date: 2003-02-11 17:21:56
Message-ID: 26545.1044984116@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)edu> writes:
> The exact same data. I just copied the data using pg_dumpall to do the upgrade
> and haven't updated either database at all since. The analyze stats should be
> pretty up-to-date but in any case should be the same for both assuming they
> get copied in the dump as well.

Uh, no, pg_dump doesn't copy pg_statistic; you must do a fresh ANALYZE
after loading the dump file.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cristian Custodio 2003-02-11 17:35:27 Fw: Priority against catalog
Previous Message Tom Lane 2003-02-11 17:14:50 Re: Is Hash Agg being used? 7.4 seems to handle this query worse than 7.3