Re: Partitioned tables, rules, triggers - Mailing list pgsql-general

From Goboxe
Subject Re: Partitioned tables, rules, triggers
Date
Msg-id 1191666863.232860.253790@19g2000hsx.googlegroups.com
Whole thread Raw
In response to Re: Partitioned tables, rules, triggers  ("Josh Tolley" <eggyknap@gmail.com>)
Responses Re: Partitioned tables, rules, triggers
List pgsql-general
Josh,

Thanks for sharing a very good info on partitioning.


On Oct 5, 10:08 pm, eggyk...@gmail.com ("Josh Tolley") wrote:
> On 10/3/07, Goboxe <hadzramin...@gmail.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



pgsql-general by date:

Previous
From: "Dave"
Date:
Subject: Foreign Key for PHP serialized data - possible?
Next
From: marwis1978
Date:
Subject: Problem with SELECT