[PERFORM] statistical table

Hello all.. I'm using PostgreSQL 8.3.. How can I get information about the hardware utilization: - CPU usage. - Disk space. - Memory allocation. thank you. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: h

[PERFORM] noapic option

In this linux mag article (http://www.linux-mag.com/cache/7516/1.html) the author describes a performance problem brought on by using the noapic boot time kernel option. Has anyone investigated whether postgres performs better with/without the noapic option? -- Sent via pgsql-performance mailing

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

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

Re: [PERFORM] CLUSTER and a problem

On Tue, Sep 15, 2009 at 9:10 PM, Andrzej Zawadzki wrote: > So, I was close - bad index... DESCending is much better. > Thanks to Grzegorz Ja\skiewicz  hi has strengthened me in the conjecture. > > I'm posting this - maybe someone will find something useful in that case. > > ps. query was and is g