postgresql long text column

Started by Josh Harrisonover 18 years ago2 messagesgeneral
Jump to latest
#1Josh Harrison
joshques@gmail.com

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

#2A. Kretschmer
andreas.kretschmer@schollglas.com
In reply to: Josh Harrison (#1)
Re: postgresql long text column

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