Re: [PERFORM] Need to run CLUSTER to keep performance

Performance problems with heavily modified tables (UPDATE or DELETE) are usually caused by not vacuuming. There are two main modes the VACUUM can run in (plain or full) and the former works in a much more aggressive way (exclusive locking, etc). Try to run VACUUM FULL VERBOSE on the table and s

Re: [PERFORM] tables with 300+ partitions

> Steven Flatt wrote: >> On 10/30/07, *Pablo Alcaraz* <[EMAIL PROTECTED] >> > wrote: >> >> I did some testing. I created a 300 partitioned empty table. Then, I >> inserted some rows on it and the perfomance was SLOW too. >> >> Is the problem with inserting to the

Re: [PERFORM] SQL Monitoring

On 10/9/07, Campbell, Lance <[EMAIL PROTECTED]> wrote: I have noticed a slight spike in the amount of CPU usage in the last few weeks. I am sure it has to do with a change or two that was made to some queries. What is the best way to log the SQL that is being executed? I would prefer to l