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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jimmie H. Apsey Sent: Monday, December 13, 2004 2:43 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ~]$ 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 [EMAIL PROTECTED] ~]$ And on 7.3.6-7 version I do: [EMAIL PROTECTED] ~]$ 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 [EMAIL PROTECTED] ~]$ 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
