postgresql long text column

От:

"Josh Harrison" <joshques@gmail.com>

Дата:

26 декабря 2007 г. в 11:08:23

Hi
I have a question about postgres long text column values.
How does it handles these long text column values? Does it put all the long text columns values from all the tables in one single place or separately?
Thanks
josh

Re: postgresql long text column

От:

"A. Kretschmer" <andreas.kretschmer@schollglas.com>

Дата:

26 декабря 2007 г. в 11:45:54

am  Wed, dem 26.12.2007, um 10:08:13 -0500 mailte Josh Harrison folgendes:
> Hi
> I have a question about postgres long text column values.
> How does it handles these long text column values? Does it put all the long
> text columns values from all the tables in one single place or separately?

PG use a TOAST-called technique.
http://www.postgresql.org/docs/8.2/interactive/storage-toast.html


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net