Performance differences 7.1 to 7.3

From: "Jimmie H(dot) Apsey" <japsey(at)futuredental(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance differences 7.1 to 7.3
Date: 2004-12-13 22:43:29
Message-ID: 41BE1B11.7030801@futuredental.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
----------------------------------------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-12-13 22:59:38 Re: Possible dump/restore bug
Previous Message William Yu 2004-12-13 22:32:15 Re: Possible dump/restore bug