James Bottomley <james.bottom...@hansenpartnership.com> wrote: > About how many files comprise this cache? Are you thinking it's > too difficult for every process to map the files?
The shared_buffers area can be mapping anywhere from about 200 files to millions of files, representing a total space of about 6MB on the low end to over 100TB on the high end. For many workloads performance falls off above a shared_buffers size of about 8GB, although for data warehousing environments larger sizes sometimes work out and to avoid write gluts it must often be limited to 1GB to 1GB. Data access is in fixed-sized pages, normally of 8KB each. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers