From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Jimmie H(dot) Apsey" <japsey(at)futuredental(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance differences 7.1 to 7.3 |
Date: | 2004-12-13 23:11:11 |
Message-ID: | D425483C2C5C9F49B5B7A41F89441547055723@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I assume that the schema is identical on both systems.
After running vacuum on both systems [for each of the underlying tables
in tpv], what does explain say about the queries?
Are the shared memory buffers identical on both systems?
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jimmie H. Apsey
Sent: Monday, December 13, 2004 2:43 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Performance differences 7.1 to 7.3
Hello all,
I have just loaded Postgresql 7.3.6-7 onto a new server on the
recommendation of Tom Lane. It is part of Red Hat AS 3.
I have Postgresql 7.1.3-5 running on Red Hat AS 2.1.
I have a simple view from which I select on both systems. The 7.3.6-7
version requires 18+ seconds to do a select from a particular view.
The 7.1.3-5 version requires 3+ seconds to select from the same view.
On the 7.1.3-5 version I do:
[japsey(at)DCFRAID ~]$ time /usr/bin/psql mpt -c"select count(*) from tpv;"
count
-------
33377
(1 row)
0.000u 0.010s 0:03.55 0.2% 0+0k 0+0io 332pf+0w
[japsey(at)DCFRAID ~]$
And on 7.3.6-7 version I do:
[japsey(at)DCFRAID ~]$ time /usr/bin/psql mpt -c"select count(*) from tpv;"
count
-------
33377
(1 row)
0.010u 0.000s 0:18.38 0.0% 0+0k 0+0io 362pf+0w
[japsey(at)DCFRAID ~]$
Does anyone have any clues as to where I should be looking for
tuning/whatever?
Jim Apsey
------------------------------------------------------------------------
----------------------------------
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-12-13 23:25:03 | Re: Corrupt RTREE index |
Previous Message | Tom Lane | 2004-12-13 22:59:38 | Re: Possible dump/restore bug |