Re: [HACKERS] LONG

Поиск
Список
Период
Сортировка
Искать
От
wieck@debis.com (Jan Wieck)
Тема
Re: [HACKERS] LONG
Дата
Msg-id
m11wv7m-0003kGC@orion.SAPserv.Hamburg.dsh.de
Ответ на
Re: [HACKERS] LONG (Bruce Momjian)
Список
Дерево обсуждения
LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG Tom Lane <tgl@sss.pgh.pa.us>
RE: [HACKERS] LONG "Hiroshi Inoue" <Inoue@tpf.co.jp>
Re: [HACKERS] LONG Tom Lane <tgl@sss.pgh.pa.us>
RE: [HACKERS] LONG "Hiroshi Inoue" <Inoue@tpf.co.jp>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
libpq questions...when threads collide Don Baccus <dhogaza@pacifier.com>
Re: [HACKERS] libpq questions...when threads collide Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] libpq questions...when threads collide Don Baccus <dhogaza@pacifier.com>
Re: [HACKERS] libpq questions...when threads collide Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] libpq questions...when threads collide Don Baccus <dhogaza@pacifier.com>
Re: [HACKERS] libpq questions...when threads collide Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] libpq questions...when threads collide Vince Vielhaber <vev@michvhf.com>
Re: [HACKERS] libpq questions...when threads collide Don Baccus <dhogaza@pacifier.com>
Re: [HACKERS] libpq questions...when threads collide Vince Vielhaber <vev@michvhf.com>
Re: [HACKERS] libpq questions...when threads collide Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] libpq questions...when threads collide Peter Eisentraut <e99re41@DoCS.UU.SE>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
RE: [HACKERS] LONG "Hiroshi Inoue" <Inoue@tpf.co.jp>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
RE: [HACKERS] LONG "Hiroshi Inoue" <Inoue@tpf.co.jp>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
RE: [HACKERS] LONG "Hiroshi Inoue" <Inoue@tpf.co.jp>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Tom Lane <tgl@sss.pgh.pa.us>
Jesus, what have I done (was: LONG) wieck@debis.com (Jan Wieck)
Re: Jesus, what have I done (was: LONG) Bruce Momjian <pgman@candle.pha.pa.us>
Re: Jesus, what have I done (was: LONG) wieck@debis.com (Jan Wieck)
Re: [HACKERS] Re: Jesus, what have I done (was: LONG) Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Re: Jesus, what have I done (was: LONG) Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] Re: Jesus, what have I done (was: LONG) Bruce Momjian <pgman@candle.pha.pa.us>
Re: Jesus, what have I done (was: LONG) Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG Peter Eisentraut <e99re41@DoCS.UU.SE>
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] LONG Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] LONG Don Baccus <dhogaza@pacifier.com>
Last thoughts about LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] Last thoughts about LONG Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Last thoughts about LONG wieck@debis.com (Jan Wieck)
Re: [HACKERS] Last thoughts about LONG Peter Eisentraut <e99re41@DoCS.UU.SE>
Re: [HACKERS] Last thoughts about LONG Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Last thoughts about LONG wieck@debis.com (Jan Wieck)
Bruce Momjian wrote:

> > While this is great and all, what will happen when long tuples finally get
> > done? Will you remove this, or keep it, or just make LONG and TEXT
> > equivalent? I fear that elaborate structures will be put in place here
> > that might perhaps only be of use for one release cycle.
>
> I think the idea is that Jan's idea is better than chaining tuples.

    Just as Tom already pointed out, it cannot completely replace
    tuple chaining because of the atomicy  assumption  of  single
    fsync(2)  operation  in  current code. Due to this, we cannot
    get around the cases LONG will leave open by  simply  raising
    BLKSIZE, we instead need to tackle that anyways.

    But I believe LONG would still be something worth the efford.
    It will lower the pressure on chained tuples, giving us  more
    time  to  build  a really good solution, and I think LONG can
    survive tuple chaining and live in coexistance with  it.   As
    said  in my last mail, I still believe that not touching LONG
    values at UPDATE can avoid storing the same huge value again.
    And that's a benefit, tuple chaining will never give us.

    Remember:  If  your only tool is a hammer, anything MUST look
    like a nail.  So why not provide a richer set of tools?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #
В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [HACKERS] LONG
FAQ