pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedshared_buffers setting
3+ messages / 2 participants
[nested] [flat]
* shared_buffers setting
@ 2008-09-15 22:22 kevin kempter <kevin@kevinkempterllc.com>
2008-09-16 01:10 ` Re: shared_buffers setting Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: kevin kempter @ 2008-09-15 22:22 UTC (permalink / raw)
To: pgsql-admin
Hi All;
I'm unclear per the docs what the effect is of specifying a shared
buffers value without a kB or an MB at the end.
For example if I specify shared buffers as:
shared_buffers = 5000
would this equate to 5000 8K pages, or 5000K, 5000bytes?
I usually specify the buffers in MB but I want to be sure I'm tuning
an existing install properly - the previous DBA has used the
convention above.
Thanks in advance
/Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: shared_buffers setting
2008-09-15 22:22 shared_buffers setting kevin kempter <kevin@kevinkempterllc.com>
@ 2008-09-16 01:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-09-16 01:28 ` Re: shared_buffers setting kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2008-09-16 01:10 UTC (permalink / raw)
To: kevin kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin
kevin kempter <kevin@kevinkempterllc.com> writes:
> I'm unclear per the docs what the effect is of specifying a shared
> buffers value without a kB or an MB at the end.
> For example if I specify shared buffers as:
> shared_buffers = 5000
> would this equate to 5000 8K pages, or 5000K, 5000bytes?
Pages. When in doubt, look at the units column of pg_settings.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: shared_buffers setting
2008-09-15 22:22 shared_buffers setting kevin kempter <kevin@kevinkempterllc.com>
2008-09-16 01:10 ` Re: shared_buffers setting Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-09-16 01:28 ` kevin kempter <kevin@kevinkempterllc.com>
0 siblings, 0 replies; 3+ messages in thread
From: kevin kempter @ 2008-09-16 01:28 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Thanks !
On Sep 15, 2008, at 7:10 PM, Tom Lane wrote:
> kevin kempter <kevin@kevinkempterllc.com> writes:
>> I'm unclear per the docs what the effect is of specifying a shared
>> buffers value without a kB or an MB at the end.
>> For example if I specify shared buffers as:
>> shared_buffers = 5000
>> would this equate to 5000 8K pages, or 5000K, 5000bytes?
>
> Pages. When in doubt, look at the units column of pg_settings.
>
> regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-16 01:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-15 22:22 shared_buffers setting kevin kempter <kevin@kevinkempterllc.com>
2008-09-16 01:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-09-16 01:28 ` kevin kempter <kevin@kevinkempterllc.com>
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