| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Alter/update large tables - VERRRY annoying behaviour! |
| Date: | 2002-04-15 23:16:07 |
| Message-ID: | Pine.LNX.4.21.0204160014030.20382-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-bugs pgsql-general pgsql-patches |
It's sad replying to my own question [of sorts] but...
On Mon, 15 Apr 2002, Nigel J. Andrews wrote:
>
> On Mon, 15 Apr 2002, Dmitry Tkach wrote:
>
> > Neil Conway wrote:
> >
> >> On Mon, 15 Apr 2002 13:07:20 -0400
> >> "Dmitry Tkach" <dmitry(at)openratings(dot)com> wrote:
> >
> >>> First of all, a question for you - is ANY update to a table equivalent (in
> this respect) to a delete+insert?
> >
> >> Yes, AFAIK -- MVCC requires this.
> >
> > What's MVCC?
>
> Funny, I was about to ask that question. Something about variable size of
> fields in the physical storage?
I've remembered, alsmot: Multi Version ConCurrency?
[plenty deleted from those quoted messages but they you all realised that or
don't care]
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bojan Belovic | 2002-04-16 00:11:18 | Killing a child process |
| Previous Message | Nigel J. Andrews | 2002-04-15 22:59:49 | Re: Alter/update large tables - VERRRY annoying behaviour! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-04-16 00:54:26 | Re: 7.2 crash... |
| Previous Message | Nigel J. Andrews | 2002-04-15 22:59:49 | Re: Alter/update large tables - VERRRY annoying behaviour! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-04-15 23:36:04 | Re: [GENERAL] Notify argument? |
| Previous Message | Nigel J. Andrews | 2002-04-15 22:59:49 | Re: Alter/update large tables - VERRRY annoying behaviour! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bistey Csaba | 2002-04-15 23:30:23 | libpq, psql hungarian translation |
| Previous Message | Bruce Momjian | 2002-04-15 23:06:18 | Re: default values for views |