Re: 2 very newbie questions

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

In response to

Browse pgsql-general by date

  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?