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(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+