FAQ

Sandeep Gupta writes:
details regarding buffer usage:
[ 100% buffer hit rate ]
Your database is evidently fully cached in memory. If that's the
operating mode you expect, you need to change the planner's cost
parameters, in particular reduce random_page_cost to equal seq_page_cost.
There is plenty of material about this on the PG wiki or in the
pgsql-performance archives.

    regards, tom lane

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 8 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJul 31, '13 at 7:09p
activeAug 2, '13 at 7:08p
posts8
users5
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2018 Grokbase