hi, firends, what's the difference between using PostgreSQL's share buffer and os's file buffer?

From: sunpeng <bluevaley(at)gmail(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: hi, firends, what's the difference between using PostgreSQL's share buffer and os's file buffer?
Date: 2011-11-17 03:04:11
Message-ID: CAOYKhLrYEzZYKBA-ieZHREyynoiDUPdh+7cGwVrQv0YXodUA8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, firends,
I have a 64bit 128GB machine, I have two choices:
1. I could set PostgreSQL share_buffer to a large value, such
as 100GB, let os uses the remaining 28G memory for file system buffer
2. I also could set PostgreSQL share_buffer to a small value,
such as 10GB, let os uses the remaining 118G memory for file system buffer
what's the difference between this two different methods in
PostgreSQL? Which one is prefered?
Thanks!
peng

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-11-17 04:52:26 Re: Is it ever necessary to vacuum a table that only gets inserts/updates?
Previous Message Shigeru Hanada 2011-11-17 02:18:58 Re: Foreign Tables