Re: Monthly table partitioning for fast purges?

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                                                      |
+-----------------------------------------------------------------+