Re: Partitioning feature ...
| От | Nikhil Sontakke |
|---|---|
| Тема | Re: Partitioning feature ... |
| Дата | |
| Msg-id | a301bfd90903230439n963540n3998ea0bfca56f0f@mail.gmail.com обсуждение исходный текст |
| Ответ на | Partitioning feature ... (Kedar Potdar <kedar.potdar@gmail.com>) |
| Ответы |
Re: Partitioning feature ...
|
| Список | pgsql-hackers |
Hi Kedar,
http://www.enterprisedb.com
The syntax used conforms to most of the suggestions mentioned in http://archives.postgresql.org/pgsql-hackers/2008-01/msg00413.php, barring the following:
-- Specification of partition names is optional. System will be able to generate partition names in such cases.
-- Sub partitioning
I was wondering if there is a need to mention the type of partition while dropping it.
E.g
ALTER table x DROP RANGE PARTITION x_part;
The type of partition (RANGE, HASH) could be dropped according to me.
We are maintaining a system catalog(pg_partition) for partition meta-data. System will look-up this table to find appropriate partition to operate on.
System internally uses low-level 'C' triggers to row-movement.
Can you elaborate more on how do you handle updates with these triggers?
Regards,
Nikhils
--
В списке pgsql-hackers по дате отправления: