Quoting Barry Lind <[EMAIL PROTECTED]>:
>
>
> What I see when running the V3 protocol under 'top' is that the postgres
> processes are routinely using 15% or more of the CPU each, when running
> the V2 protocol they use more like 0.3%.
>
>
>
> Does anyone have any suggestions on an approac
We just moved a large production instance of ours from
Oracle to Postgres 8.0.3 on linux. When running on Oracle the machine
hummed along using about 5% of the CPU easily handling the fairly constant load,
after moving the data to Postgres the machine was pretty much maxed out on CPU
and c
