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 <dhu...@letourneautechnologies.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. > >
