| From: | Robert Gravsjö <robert(at)blogg(dot)se> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Table partitioning |
| Date: | 2009-05-20 12:04:10 |
| Message-ID: | 4A13F1BA.2080302@blogg.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
While reading through the docs on Partitioning,
http://www.postgresql.org/docs/current/static/ddl-partitioning.html,
I got to wonder about the example given.
The text in 5.9.2 states, item 1 in the first section, that the master
table will contain no data. This is later confirmed by the example code
where the trigger function, measurement_insert_trigger, redirects
inserts to child tables and, failing to do so, raises an exception.
Is there a reason to avoid populating the master table other that the
cost of the data always being included when querying?
My concern is that I would like to have the ELSE clause in
measurement_insert_trigger just raise a log message and then return NEW.
Am I missing some huge drawback?
Regards,
roppert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Geoghegan | 2009-05-20 12:39:50 | Re: Suggested way of associating PG user metadata with record |
| Previous Message | Leif B. Kristensen | 2009-05-20 11:53:43 | Re: [Windows] Feedback on PG? |