Re: Joel's Performance Issues WAS : Opteron vs Xeon

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Joel Fradkin" <jfradkin(at)wazagua(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Date: 2005-04-21 03:32:14
Message-ID: 200504202032.14276.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Joel,

Ok, please try this:

ALTER TABLE tblresponseheader ALTER COLUMN clientnum SET STATISTICS 1000;
ALTER TABLE tblresponseheader ALTER COLUMN locationid SET STATISTICS 1000;
ALTER TABLE tbllocation ALTER COLUMN clientnum SET STATISTICS 1000;
ALTER TABLE tbllocation ALTER COLUMN divisionid SET STATISTICS 1000;
ALTER TABLE tbllocation ALTER COLUMN regionid SET STATISTICS 1000;
ANALYZE tblresponseheader;
ANALYZE tbllocation;

Then run the EXPLAIN ANALYZE again. (on Linux)

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-04-21 04:35:32 Re: Joel's Performance Issues WAS : Opteron vs Xeon
Previous Message Christopher Browne 2005-04-21 01:56:03 Re: Opteron vs Xeon