From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] mdnblocks is an amazing time sink in huge relations |
Date: | 1999-10-20 04:30:38 |
Message-ID: | 380D456E.B99A7CF8@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hiroshi Inoue wrote:
>
> > > Does this mean the following ?
> > >
> > > 1. shared cache holds committed system tuples.
> > > 2. private cache holds uncommitted system tuples.
> > > 3. relpages of shared cache are updated immediately by
> > > phisical change and corresponding buffer pages are
> > > marked dirty.
> > > 4. on commit, the contents of uncommitted tuples except
> > > relpages,reltuples,... are copied to correponding tuples
> > ^^^^^^^^^
> > reltuples in shared catalog cache (SCC) will be updated!
> > If transaction inserted some tuples then SCC->reltuples
> > will be incremented, etc.
> >
>
> System tuples are only modifiled or (insert and delet)ed like
> user tuples when reltuples are updated ?
> If only modified,we couldn't use it in SERIALIZABLE mode.
^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^
...this...
I'm not sure that we must provide read consistency
for internal-use columns...
Nevertheless, I agreed that keeping internal-use columns
in table is bad thing, but let's do it for awhile: I believe
that someday we'll re-implement our mdmgr - using separate
file for each table/index is bad thing too, - and move these
columns "somewhere else" in that day.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-10-20 04:52:32 | Re: [HACKERS] current_time? |
Previous Message | Tom Lane | 1999-10-20 04:29:36 | Re: [HACKERS] mdnblocks is an amazing time sink in huge relations |