Re: [PERFORM] Possible causes of sometimes slow single-row UPDATE with trivial indexed condition?

2009-09-19 Thread Vlad Romascanu
d and <5% of all other UPDATE queries running on the system across other tables in the same tablespace over, again, the same period. V. - Original Message - From: "Andy Colson" To: "Vlad Romascanu" ; Sent: Thursday, September 17, 2009 9:45 AM Subject: R

[PERFORM] Possible causes of sometimes slow single-row UPDATE with trivial indexed condition?

2009-09-16 Thread Vlad Romascanu
Problem occurs when running (in production) Postgres 8.3.7 64-bit (from RPM) on Ubuntu 8.04.2, on an Amazon EC2 (xen) "Large" instance (8GB RAM), with the DB on a 50GB EC2 block device. Problem does not occur when running (in staging/pre-production) Postgres 8.3.5 32-bit (from RPM) on Ubuntu 8.0