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
> 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.
pgsql-performance by date
|Next:||From: Shridhar Daithankar||Date: 2004-02-17 11:00:52|
|Subject: Re: Slow response of PostgreSQL|
|Previous:||From: Eric Jain||Date: 2004-02-17 10:36:35|
|Subject: Re: very large db performance question|