Re: [HACKERS] Performance problem partially identified - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Performance problem partially identified
Date
Msg-id 374F73EF.B47F4013@krs.ru
Whole thread Raw
In response to Performance problem partially identified  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hannu Krosing wrote:
> 
> Tom Lane wrote:
> >
> > It looks to me like something is broken such that bufmgr.c *always*
> > thinks that a buffer is dirty (and needs written out) when it is
> > released.
> 
> That could also explain why the performance increases quite noticeably
> even for _select_ queries when you specify "no fsync" for backend.
> (I have'nt checked it lately, but it was the case about a year ago)

Enev selects try to update t_infomask to avoid pg_log lookup
for other queries.

Vadim


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Performance problem partially identified
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Re: Performance problem partially identified