Re: [PERFORM] Clearing rows periodically

2003-07-18 Thread Andrew Sullivan
On Fri, Jul 18, 2003 at 12:55:12AM -0600, Martin Foster wrote: The other table follows a sequential order and carries more columns of information. However, this table clears it's entry nightly and with current settings will delete roughly a days traffic sitting at 50K rows of information.

Re: [PERFORM] Clearing rows periodically

2003-07-18 Thread Tom Lane
Martin Foster [EMAIL PROTECTED] writes: My question is, should the purging of rows be done more often then once a day for both tables. Is this why performance seems to take a hit specifically? Given that the hourly purge seems to work well for you, I'd suggest trying it on both tables.