e: [PERFORM] Possible causes of sometimes slow single-row UPDATE
with trivial indexed condition?
Vlad Romascanu wrote:
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
Vlad Romascanu wrote:
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 (
Vlad Romascanu wrote:
> 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.
Hmm - don't know what the characteristics of running PG on EC2 are. This
might be so
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