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

From Vadim Mikheev
Subject Re: [HACKERS] Re: Performance problem partially identified
Date
Msg-id 374F76B8.4BF9F23A@krs.ru
Whole thread Raw
In response to Re: Performance problem partially identified  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> Further info:
> 
> I think this behavior may be state-dependent.  The first update after
> loading the table rewrites all the blocks, but subsequent ones do not.
> Is it just a matter of marking recently-written tuples as confirmed
> good?  If so, then there is not a problem (or at least, not as big
> a problem as I thought).

Exactly!

One have to run vacuum after loading a big amount of data.

Vadim


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Performance problem partially identified
Next
From: Vadim Mikheev
Date:
Subject: Re: [COMMITTERS] 'pgsql/src/backend/storage/buffer bufmgr.c'