Hi,
Thanks for your suggestions. Here's an output of the explain analyse.
I'll change the shared_buffers and look at the behaviour again.
"Limit (cost=59.53..59.53 rows=1 width=28) (actual time=15.681..15.681
rows=1 loops=1)"
" -> Sort (cost=59.53..59.53 rows=1 width=28) (actual
time=15.678..
> Hi all,
>
>
>
> I have a postgres installation thats running under 70-80% CPU usage
> while
>
> an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
>
>
>
> Here's the scenario,
>
> 300 queries/second
>
> Server: Postgres 8.1.4 on win2k server
>
> CPU: Dual Xeon 3.6 Ghz,
>
> Me
On 11/23/06, Gopal <[EMAIL PROTECTED]> wrote:
I have a postgres installation thats running under 70-80% CPU usage while
an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
i somehow doubt ms sql server is 35x faster than postgresql in
production environments, even on window
On Thu, 23 Nov 2006 22:31:40 -
"Gopal" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
>
>
> I have a postgres installation thats running under 70-80% CPU usage
> while
>
> an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
>
>
>
> Here's the scenario,
>
> 300 queries/sec
or is it
distributed among all the processes?
try raising work_mem. we have set it to 30MB
- thomas
- Original Message -
From: Gopal
To: pgsql-general@postgresql.org
Sent: Thursday, November 23, 2006 11:31 PM
Subject: [GENERAL] Postgres scalability and performance on wi
Hi all,
I have a postgres installation thats running under 70-80% CPU usage
while
an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load.
Here's the scenario,
300 queries/second
Server: Postgres 8.1.4 on win2k server
CPU: Dual Xeon 3.6 Ghz,
Memory: 4GB RAM
Disks: 3 x
