Re: Monthly table partitioning for fast purges?
От | Ron Johnson |
---|---|
Тема | Re: Monthly table partitioning for fast purges? |
Дата | |
Msg-id | 1059950993.28344.48.camel@haggis обсуждение исходный текст |
Ответ на | Re: Monthly table partitioning for fast purges? ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>) |
Список | pgsql-general |
On Sun, 2003-08-03 at 06:31, Shridhar Daithankar wrote: > On 1 Aug 2003 at 13:46, Roger Hand wrote: [snip] > Here is what you can do. > > * Create a empty base table. > * Create a trigger the directs the select on timestamps accordingly > * Write a schedule to create a new table at the start of every month and update > the trigger accordingly > * Create and maintain rules to insert into base table depending upon the > timestamp. > > This is just a rough idea. > > There might be fair amount of work to get this working but surely it is not > imposible. And you get a big performance hit when all those records are moved. Partitioning "should" be put on the TODO list soon after tablespaces (or DBA-defined directories) is implemented. -- +-----------------------------------------------------------------+ | Ron Johnson, Jr. Home: ron.l.johnson@cox.net | | Jefferson, LA USA | | | | "I'm not a vegetarian because I love animals, I'm a vegetarian | | because I hate vegetables!" | | unknown | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: