Skip site navigation (1) Skip section navigation (2)

Re: Slow response of PostgreSQL

From: "Saleem Burhani Baloch" <peseek(at)khi(dot)wol(dot)net(dot)pk>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow response of PostgreSQL
Date: 2004-02-17 10:39:09
Message-ID: 200402171039.i1HAd9u25077@ns2.khi.wol.net.pk (view raw or flat)
Thread:
Lists: pgsql-performance
I changed the conf as you wrote. But now the time is changed from 50 sec to 65 sec. :(
I have not more 256 MB ram now.
When I execute the query the 
Postmaster takes about 1.8 MB
Postgres session takes 18 MB ram only.
& psql takes 1.3 MB.

After the query finishes the 
Postgres session reducess memeory and just uses 10 MB ram.

I have a question why MS-SQL with 256 MB RAM gives result in 2 sec ?? If I have low memory Postgres should give result in 10 sec as compared to MS-SQL.

Looking forward for comments & suggestions

Saleem

> This is a shockingly bad postgresql.conf.  I'm not surprised you have 
> performance problems.  Change this:
> 
> effective_cache_size = 4000
> sort_mem = 4096
> shared_buffers = 1000
> wal_buffers = 8
> 
> Also, you need a LOT more RAM in your PostgreSQL machine, at least half 
> a gig for a basic database server.
> 
> 
> Chris




Responses

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2004-02-17 11:00:52
Subject: Re: Slow response of PostgreSQL
Previous:From: Eric JainDate: 2004-02-17 10:36:35
Subject: Re: very large db performance question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group