From: | Goboxe <hadzramin(dot)ar(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Partitioned table limitation |
Date: | 2007-10-02 00:28:46 |
Message-ID: | 1191284926.905585.187280@50g2000hsm.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jason L. Buberel | 2007-10-02 05:32:14 | Re: Strange discrepancy in query performance... |
Previous Message | Tom Lane | 2007-10-02 00:01:42 | Re: Strange discrepancy in query performance... |