| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | tfinneid(at)student(dot)matnat(dot)uio(dot)no |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: select count() out of memory |
| Date: | 2007-10-25 16:16:31 |
| Message-ID: | 20071025161631.GE23566@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
tfinneid(at)student(dot)matnat(dot)uio(dot)no wrote:
> > tfinneid(at)student(dot)matnat(dot)uio(dot)no wrote:
> >> Thats good enough for me, thats exactly what I want.
> >
> > In that case, why use partitions at all? They are simple independent
> > tables.
>
> For two reasons,
> - the data logically belongs together.
> - because its more practical to create tables as childs of a parent table
> than as independent tables.
> - changes to the table is applied to all partitions, and prohibits
> tables with different dd.
> - performing the create operation does not require the source code to
> contain the ddl of the parent table.
You can use CREATE TABLE LIKE, which copies the definition but does not
set the inheritance.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-10-25 16:18:36 | Re: select count() out of memory |
| Previous Message | Joshua D. Drake | 2007-10-25 16:16:08 | Re: subversion support? |