Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...) - Mailing list pgsql-performance

From Vitalii Tymchyshyn
Subject Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)
Date
Msg-id 4E770D59.3090906@gmail.com
Whole thread Raw
In response to PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)  (Stefan Keller <sfkeller@gmail.com>)
Responses Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)
List pgsql-performance
Tree view 
17.09.11 23:01, Stefan Keller написав(ла):
> * more... ?
What I miss from my DB2 UDB days are buffer pools. In PostgreSQL terms
this would be part of shared buffers dedicated to a relation or a set of
relations. When you have a big DB (not fitting in memory) you also
usually want some small tables/indexes be in memory, no matter what
other load DB has.
Complimentary features are:
1) Relations preloading at startup - ensure this relation are in memory.
2) Per buffer pool (or relation) page costs - tell it that this
indexes/tables ARE in memory

Best regards, Vitalii Tymchyshyn.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Constraint exclusion on UNION ALL subqueries with WHERE conditions
Next
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)