Table partitioning
| От | Robert Gravsjö |
|---|---|
| Тема | Table partitioning |
| Дата | |
| Msg-id | 4A13F1BA.2080302@blogg.se обсуждение исходный текст |
| Ответы |
Re: Table partitioning
|
| Список | 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
В списке pgsql-general по дате отправления: