Re: Partitioned table limitation

>
> I've played around with as many as 1,000 child tables.  By then, the
> planning time becomes noticeably longer than for a single table, but
> the response time is still so much faster that it's worth it.  Note
> I'm talking only a fraction of a second planning time, even at 1,000
> tables.
>
> If you are going over 100 tables, make sure you're using triggers for
> updating the child tables not rules, as rules are far too slow when
> there's over 50 or so tables to look choose from.
>
> ---------------------------(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- Hide quoted text -
>
> - Show quoted text -


Scott,

Could you share a snippet on how to use trigger for this?


TQ,
G