We are looking to optimize the query I was talking about last week
which is killing our system.
We have explain and analyze which tell us about the cost of a query
time-wise, but what does one use to determine (and trace / predict?)
“Don't eat anything you've ever seen advertised on TV”
- Michael Pollan, author of "In Defense of Food"
pgsql-performance by date
|Next:||From: Vincent de Phily||Date: 2009-09-21 14:50:23|
|Subject: Re: slow query : very simple delete, 100% cpu, nearly no disk activity|
|Previous:||From: Florian Weimer||Date: 2009-09-21 08:51:22|
|Subject: Re: Index row requires 9324 bytes maximum size is 8191|