Re: Question about OID and TCID

From: Matthew Walden <matthew(dot)walden(at)bcs(dot)org>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: zhipan Wang <wzhipan(at)yahoo(dot)com>, postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question about OID and TCID
Date: 2010-11-28 11:54:49
Message-ID: AANLkTikTL1ny49nqYC62VqqEme5PHp3-a3d-5FnZVg2q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> So the in-place update is a vital part of the program, because a range of
values
> of column col should be stored together on the disk. Is there any way to
do such
> a in-place update without generating much extra overhead?
>

Although in-place update is not possible, can he not use partitioning to at
least try to store the data together based on the value of column col?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Kupershmidt 2010-11-28 15:34:21 Re: [GENERAL] column-level update privs + lock table
Previous Message Sofer, Yuval 2010-11-28 11:37:41 ERROR: xlog flush request 17/4D6C2720 is not satisfied