Gabi Julien <gabi.julien@xxxxxxxxxxxxx> writes: > In my case, I do not know how big my cache will be. That makes it awfully hard to use shared memory. > If shared memory turns out too difficult to use, I could create > separate caches for each postgresql processes. That's what I'd recommend. A big advantage of private caches is that you don't have any need to manage concurrent access, which simplifies the code and avoids contention. All the caches that the core Postgres code maintains are per-backend. > This would be a waste > of space but it might be better then nothing. In this case, do I need > to make my code thread safe? In other words, is postgresql using more > then one thread per processes? No. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
