From: | jake(at)omnimode(dot)com (jake johnson) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: More Praise for 7.4RC2 |
Date: | 2003-11-12 17:04:59 |
Message-ID: | 8897a0de.0311120904.1d10900f@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
reece(at)in-machina(dot)com (Reece Hart) wrote in message news:<1068597494(dot)28850(dot)266(dot)camel(at)tallac>...
[...snip...]
> The cost estimates give the right qualitative feel. 7.3.4 took >30
> minutes for this query whereas 7.4RC2 responds essentially
> instantaneously.
>
[...snip...]
I also posted about the performance increase of 7.4, but I think that
much of the difference you're seeing (because it's such a large
difference) is probably due to the cleanliness of a newly restored
database from backup. Perhaps a vacuum analyze could have improved
that 30+ minute response time on 7.3.4.
I too posted about the performance improvement, seeing about 200% at
first after restoring from backup. After some transactions, however,
I'd say its more like 100% - 125% improvement. I'm still particularly
impressed with the improvement in the select count(*) query
performance, which is about 100% improved.
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2003-11-12 17:13:11 | procpid in pg_stat_activity but no correspoding backend |
Previous Message | Jordan Henderson | 2003-11-12 16:34:14 | Re: [HACKERS] Proposal for a cascaded master-slave replication system |