Re: Partitioned tables, rules, triggers

From: Goboxe <hadzramin(dot)ar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Partitioned tables, rules, triggers
Date: 2007-10-06 10:34:23
Message-ID: 1191666863.232860.253790@19g2000hsx.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Josh,

Thanks for sharing a very good info on partitioning.

On Oct 5, 10:08 pm, eggyk(dot)(dot)(dot)(at)gmail(dot)com ("Josh Tolley") wrote:
> On 10/3/07, Goboxe <hadzramin(dot)(dot)(dot)(at)gmail(dot)com> wrote:
>
> > Hi,
>
> > I have two questions on the above:
>
> > 1. I found in some postings recommended to use triggers instead of
> > rules. Is this documented somewhere?
>
> A howto is available athttp://images.omniti.net/omniti.com/talks/partitions-public.pdf
>
> - Josh/eggyknap
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2007-10-06 14:37:51 Should I install PostgreSQL 8.2.5?
Previous Message Ben 2007-10-06 00:49:59 Re: Very asynchrnous replication system