Re: [HACKERS] Re: Performance problem partially identified

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: Performance problem partially identified
Date: 1999-05-29 05:10:16
Message-ID: 374F76B8.4BF9F23A@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-05-29 05:23:07 Re: [COMMITTERS] 'pgsql/src/backend/storage/buffer bufmgr.c'
Previous Message Vadim Mikheev 1999-05-29 04:58:23 Re: [HACKERS] Performance problem partially identified