Postgres Performance -- page size

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Richard
    #1

    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
    Tags: None
    • rstp
      #2
      Re: Postgres Performance -- page size

      Richard wrote:[color=blue]
      > 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[/color]
      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
      Error 404 - Not Found
      http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

      and it is easy to follow. Check it out.

      [color=blue]
      > 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[/color]

      Ron

        Comment

        Previous template Next
        Working...