Re: More tablescanning fun - Mailing list pgsql-performance

From Hannu Krosing
Subject Re: More tablescanning fun
Date
Msg-id 1051426250.1860.1.camel@fuji.krosing.net
Whole thread Raw
In response to Re: More tablescanning fun  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-performance
Jim C. Nasby kirjutas R, 25.04.2003 kell 19:56:
> I'm not familiar enough with pgsql's guts to know how big an impact
> updates across pages are, or if they even happen often at all. If you're
> not maintaining a clustered table, couldn't all updates just occur
> in-place?

In postgres _no_ updates happen in-place. The MVCC concurrency works by
always inserting a new tuple on update .

-----------
Hannu


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Automatic analyze on select into
Next
From: Jeremy Andrus
Date:
Subject: pgsql BLOB issues