From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | db slowness + upgrade prospects |
Date: | 2005-07-25 21:17:03 |
Message-ID: | 200507251517.03241.pgsql@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Our inserts and updates on an older 7.3.4 cluster are very slow
(0.3s-0.9s) for any/all tables, new and old. I know an upgrade
may be in order, but I have a number of other 7.3.4 legacy
clusters, and I'd really like to understand the cause and if an
upgrade is going to solve this problem (downtime is sensitive,
of course).
As a test case, I created the following table on both the slow
cluster and a newly created test cluster on the same box:
create table foo(id integer, msg text)
I measured less than 10 inserts/second max on the slow cluster.
On the new cluster on the same system, I measured 5000
inserts/second. So I figure it's something in the system
relations. Autovac had been disabled for a few days at least.
I did a db-wide vacuum/analyze, still no speedup.
So two questions: 1) Any ideas on what is the cause? 2) How is
this avoided in 7.4.8 or 8.0.3?
Ed
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2005-07-25 21:17:46 | pgsql client/server compatibility matrix? |
Previous Message | Tony Caduto | 2005-07-25 20:41:47 | Re: Wishlist? |