Re: [PERFORM] PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)

2011-09-19 Thread Vitalii Tymchyshyn
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

Re: [PERFORM] PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)

2011-09-19 Thread Cédric Villemain
2011/9/19 Vitalii Tymchyshyn tiv...@gmail.com: 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

Re: [PERFORM] PostgreSQL-related topics of theses and seminary works sought (Was: Hash index use presently(?) discouraged...)

2011-09-19 Thread Vitalii Tymchyshyn
Hello. I did read and AFAIR sometimes responded on this long discussions. The main point for me is that many DBAs dont want to have even more random plans with postgresql knowing what's in memory now and using this information directly in runtime. I also think this point is valid. What I