Re: 8.3devel slower than 8.2 under read-only load - Mailing list pgsql-hackers

From Guillaume Smet
Subject Re: 8.3devel slower than 8.2 under read-only load
Date
Msg-id 1d4e0c10711251030o3c36cb64h7c9b0c448ba6e6c9@mail.gmail.com
Whole thread Raw
In response to Re: 8.3devel slower than 8.2 under read-only load  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.3devel slower than 8.2 under read-only load  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: 8.3devel slower than 8.2 under read-only load  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Nov 25, 2007 6:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Would you show us the test case you're using?

Sure, it's the same queries I posted earlier. My pgbench script is the
following:
BEGIN

select libvil from vilsitelang where codelang='FRA' and codevil='LYO'
select TL.motsclesmetatags, TL.descriptifmeta, TL.motcleoverture_l,
TL.motcleoverture_c, TL.baselinetheme from themelang TL where
TL.codeth = 'ASS' and TL.codelang = 'FRA'
SELECT libvilpubwoo, codelang, codepays, petiteville FROM vilsite
WHERE codevil = 'LYO'
select libvil from vilsitelang where codelang='FRA' and codevil='LYO'

END

I send a link to the data to both of you in private.

--
Guillaume


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: quote_literal(integer) does not exist
Next
From: Tom Lane
Date:
Subject: Re: 8.3devel slower than 8.2 under read-only load