Shams Khan wrote:
> *Need to increase the response time of running queries on
> server...*
> 8 CPU's and 16 cores
> [64GB RAM]
> HDD 200GB
> Database size = 40GB
Without more info, there's a bit of guesswork, but...
> maintenance_work_mem = Not initialised
I would say probably 1GB
> effecti
Hey Kevin,
Thanks for such great help :
I analyzed on query before changing parameters;
explain select count(distinct a.subsno ) from subsexpired a where
a.subsno not in (select b.subsno from subs b where b.subsno>75043 and
b.subsno<=112565) and a.subsno>75043 and a.subsno<=112565;
Maybe
explain analyze select count(distinct a.subsno ) from subsexpired a where
a.subsno not in (select b.subsno from subs b where b.subsno>75043 and
b.subsno<=112565) and a.subsno>75043 and a.subsno<=112565;
Give you more information about real excecuting time.
About postgres.conf
checkpoin
Shams Khan wrote:
> *PERFORMANCE WAS BOOSTED UP DRASTICALLY* ---when I edited the
> work_mem to 100 MB---just look at the difference;
You only showed EXPLAIN output, which only shows estimated costs.
As already suggested, try running both ways with EXPLAIN ANALYZE --
which will show both estimate
Kevin you Rocks!!!
It was really very helpful...Happy weekend!!!
--Original Message--
From: Kevin Grittner
To: Shams Khan
To: [email protected]
Subject: Re: [ADMIN] PostgreSQL Performance Tuning / Postgresql.conf and on OS
Level
Sent: Dec 15, 2012 01:50
Shams Khan wrote:
> *PE
