pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedShared buffers, Sort memory, Effective Cache Size
3+ messages / 3 participants
[nested] [flat]
* Shared buffers, Sort memory, Effective Cache Size
@ 2004-04-21 16:29 Frédéric Robinet <Fr@Mims.be>
2004-04-21 17:01 ` Re: Shared buffers, Sort memory, Effective Cache Size Qing Zhao <qzhao@supplyfx.com>
0 siblings, 1 reply; 3+ messages in thread
From: Frédéric Robinet @ 2004-04-21 16:29 UTC (permalink / raw)
To: pgsql-performance
Hello,
I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL 7.4
running on. What are the bests settings for shared buffers, sort memory and
effective cache size?
My main database have a small/mid range size: some tables may have 1 or 2
millions of records.
Thanks
Frédéric Robinet
Fr@Mims.be
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Shared buffers, Sort memory, Effective Cache Size
2004-04-21 16:29 Shared buffers, Sort memory, Effective Cache Size Frédéric Robinet <Fr@Mims.be>
@ 2004-04-21 17:01 ` Qing Zhao <qzhao@supplyfx.com>
2004-04-27 12:12 ` Re: Shared buffers, Sort memory, Effective Cache Size Manfred Koizar <mkoi-pg@aon.at>
0 siblings, 1 reply; 3+ messages in thread
From: Qing Zhao @ 2004-04-21 17:01 UTC (permalink / raw)
To: Frédéric Robinet <Fr@Mims.be>; +Cc: pgsql-performance
Hello,
I have recently configured my PG7.3 on a G5 (8GB RAM) with
shmmax set to 512MB and shared_buffer=50000, sort_mem=4096
and effective cache size = 10000. It seems working great so far but
I am wondering if I should make effctive cache size larger myself.
Tnaks!
Qing
On Apr 21, 2004, at 9:29 AM, Frédéric Robinet wrote:
> Hello,
>
> I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL
> 7.4
> running on. What are the bests settings for shared buffers, sort
> memory and
> effective cache size?
>
> My main database have a small/mid range size: some tables may have 1
> or 2
> millions of records.
>
> Thanks
>
> Frédéric Robinet
> Fr@Mims.be
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Shared buffers, Sort memory, Effective Cache Size
2004-04-21 16:29 Shared buffers, Sort memory, Effective Cache Size Frédéric Robinet <Fr@Mims.be>
2004-04-21 17:01 ` Re: Shared buffers, Sort memory, Effective Cache Size Qing Zhao <qzhao@supplyfx.com>
@ 2004-04-27 12:12 ` Manfred Koizar <mkoi-pg@aon.at>
0 siblings, 0 replies; 3+ messages in thread
From: Manfred Koizar @ 2004-04-27 12:12 UTC (permalink / raw)
To: Qing Zhao <qzhao@supplyfx.com>; +Cc: Frédéric Robinet <Fr@Mims.be>; pgsql-performance
On Wed, 21 Apr 2004 10:01:30 -0700, Qing Zhao <qzhao@supplyfx.com>
wrote:
>I have recently configured my PG7.3 on a G5 (8GB RAM) with
>shmmax set to 512MB and shared_buffer=50000, sort_mem=4096
>and effective cache size = 10000. It seems working great so far but
>I am wondering if I should make effctive cache size larger myself.
Yes, much larger! And while you are at it make shared_buffers smaller.
Servus
Manfred
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-04-27 12:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-21 16:29 Shared buffers, Sort memory, Effective Cache Size Frédéric Robinet <Fr@Mims.be>
2004-04-21 17:01 ` Qing Zhao <qzhao@supplyfx.com>
2004-04-27 12:12 ` Manfred Koizar <mkoi-pg@aon.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox