Re: automated row deletion

I think there no better way you can get around this problem. You need to
check the disk periodically and it is not to hard.

2009/10/1 Dave Huber <DHuber(at)letourneautechnologies(dot)com>

> I am inserting 250 rows of data (~2kbytes/row) every 5 seconds into a
> table (the primary key is a big serial). I need to be able to limit the size
> of the table to prevent filling up the disk. Is there a way to setup the
> table to do this automatically or do I have to periodically figure out how
> many rows are in the table and delete the oldest rows manually?
>
>
>
> Thanks,
>
> Dave
>
> ------------------------------
> This electronic mail message is intended exclusively for the individual(s)
> or entity to which it is addressed. This message, together with any
> attachment, is confidential and may contain privileged information. Any
> unauthorized review, use, printing, retaining, copying, disclosure or
> distribution is strictly prohibited. If you have received this message in
> error, please immediately advise the sender by reply email message to the
> sender and delete all copies of this message.
> THIS E-MAIL IS NOT AN OFFER OR ACCEPTANCE: Notwithstanding the Uniform
> Electronic Transactions Act or any other law of similar import, absent an
> express statement to the contrary contained in this e-mail, neither this
> e-mail nor any attachments are an offer or acceptance to enter into a
> contract, and are not intended to bind the sender, LeTourneau Technologies,
> Inc., or any of its subsidiaries, affiliates, or any other person or entity.
> WARNING: Although the company has taken reasonable precautions to ensure no
> viruses are present in this email, the company cannot accept responsibility
> for any loss or damage arising from the use of this email or attachments.
>
>