From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Heine Ferreira <heine(dot)ferreira(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 2 very newbie questions |
Date: | 2012-01-19 20:12:22 |
Message-ID: | 4F187926.3070108@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 01/19/2012 12:04 PM, Heine Ferreira wrote:
> Hi
>
> The Postgresql manual is rather huge so I would appreciate it if you
> could help me with the following 2 questions:
>
> What is an oid when creating tables and what is the purpose of it?
oid stands for Object ID. A long time ago they where used as a quick and
dirty way to generate unique sequences for a table. The use of oids in a
public table is now deprecated. If you want a unique sequence use the
serial type.
>
> What is a toast table?
It is an auxiliary table that stores information for fields when the
size of the data in the field exceeds certain limits. This does not
apply to all data types.
Better description here:
http://www.postgresql.org/docs/9.0/static/storage-toast.html
>
> Thanks
>
> H.F.
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Heine Ferreira | 2012-01-19 20:14:20 | schema question |
Previous Message | Alex Lai | 2012-01-19 20:12:03 | Re: How to improve my slow query for table have list of child table? |