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 1d4e0c10711212340x68299024p688d7ccffb7e939e@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>)
List pgsql-hackers
On Nov 22, 2007 2:17 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Another issue is that on read-only transactions there's an extra
> gettimeofday() call caused by pgstat_report_tabstats, which could be a
> problem on machines with slow gettimeofday().  However that shouldn't
> happen if you've got track_counts turned off, so if you don't see any
> difference with or without stats then it's not the problem for you.

The box is a Core2 duo box so I don't think it's the case.

track_counts on/off doesn't change anything to the results.

--
Guillaume


pgsql-hackers by date:

Previous
From: cinu
Date:
Subject: run_build.pl ~ By Andrew Dunstan
Next
From: "Albe Laurenz"
Date:
Subject: Re: backup_label and server start