Skip site navigation (1) Skip section navigation (2)

Re: limit tables size

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: MinalDate: 2005-06-27 06:34:28
Subject: Problem with startup
Previous:From: Keith WorthingtonDate: 2005-06-26 11:26:44
Subject: Re: unpacking composite values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group