470,614 Members | 1,458 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Postgres Performance -- page size

Hi,

I am trying to tuning up the performance of PSQL. I have tried
changing the cache size. I found that the default page size if 8k, I
am just wondering has any one know, if page size if biger the better
or smaller the better, what is a good number of page size? My OS is
red hat 8, and the OS page size is 4K. So should I change PSQL page
size to 4k or to 16K, 32K?

Thanks,

Richard
Nov 11 '05 #1
1 5411
Richard wrote:
Hi,

I am trying to tuning up the performance of PSQL. I have tried
changing the cache size. I found that the default page size if 8k, I default effective_cache_size is 1000 * 8KB - is this what you mean?
According to the postgresql.conf guide, you can increase it to about 25%
of available memory. There's some new documentation on configuring the
database at
http://www.varlena.com/varlena/Gener...ed_conf_e.html
and it is easy to follow. Check it out.

am just wondering has any one know, if page size if biger the better
or smaller the better, what is a good number of page size? My OS is
red hat 8, and the OS page size is 4K. So should I change PSQL page
size to 4k or to 16K, 32K?

Thanks,

Richard


Ron

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Andy Tran | last post: by
8 posts views Thread by wlcna | last post: by
3 posts views Thread by Gaetano Mendola | last post: by
8 posts views Thread by BlueBall | last post: by
6 posts views Thread by Prabu Subroto | last post: by
3 posts views Thread by ruben20 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.