Re: [PERFORM] High CPU Usage - PostgreSQL 7.3

On Mon, 10 Jul 2006, Neil Hepworth wrote: I am running PostgreSQL 7.3 on a Linux box (RHEL 2.1 - Xeon 2.8GHz with 1GB of RAM) and seeing very high CPU usage (normally over 90%) when I am running the following queries, and the queries take a long time to return; over an hour! First off, when is

[PERFORM] High CPU Usage - PostgreSQL 7.3

Hi, I am running PostgreSQL 7.3 on a Linux box (RHEL 2.1 - Xeon 2.8GHz with 1GB of RAM) and seeing very high CPU usage (normally over 90%) when I am running the following queries, and the queries take a long time to return; over an hour! CREATE TEMPORARY TABLE fttemp1600384653 AS SELECT * FROM f

Re: [PERFORM] Opteron/FreeBSD/PostgreSQL performance poor

On 7/7/06, andy rost <[EMAIL PROTECTED]> wrote: Hi Merlin, Thanks for the input. Please see below ... no problem! [aside: jeff, great advice on tps determination] >> fsync = on # turns forced synchronization > have you tried turning this off and measuring perform