From: | alex <alex(dot)ricci(at)arkantechnologies(dot)com> |
---|---|
To: | KeithW(at)NarrowPathInc(dot)com |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: limit tables size |
Date: | 2005-06-26 11:42:09 |
Message-ID: | 42BE9491.3070704@arkantechnologies.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Keith Worthington wrote:
> alex wrote:
>
>> Hi,
>>
>> Is it possible to limit the size or the number of rows of table, in a
>> FIFO mode for example ??
>>
>> Regards
>>
>> Al
>
>
> Hmmm, do you mean that every time a row is INSERTed that you want to
> delete the oldest row?
>
> How about a serial column and an AFTER INSERT trigger? The trigger
> could search for and delete the row with the smallest serial value.
> This could get real slow if your table is huge. If the volume is high
> enough then you will have to handle wrap around. You could simply
> write a script that would subtract the minimum value from all the rows
> when the serial reached the maximum.
>
Yes It may be the solution, look at the index some times and delete the
old ones ...
kind regards
Al
From | Date | Subject | |
---|---|---|---|
Next Message | Minal | 2005-06-27 06:34:28 | Problem with startup |
Previous Message | Keith Worthington | 2005-06-26 11:26:44 | Re: unpacking composite values |