Re: PostgreSQL Process memory architecture

Hi Stephen,

I have some basic question -  How do I add this flags CATCACHE_STATS and CATCACHE_FORCE_RELEASE when building
postgresql?

I added it to src/Makefile.global in this line:
CPPFLAGS =  -D_GNU_SOURCE -DCATCACHE_STATS -DCATCACHE_FORCE_RELEASE

And changed log level to debug2, but it doesn't log the catcache statistcs

Lior


-----Original Message-----
From: Stephen Frost [mailto:sfrost@snowman.net]
Sent: Monday, May 27, 2013 16:44
To: Ben Zeev, Lior
Cc: Atri Sharma; Pg Hackers
Subject: Re: [HACKERS] PostgreSQL Process memory architecture

* Ben Zeev, Lior (lior.ben-zeev@hp.com) wrote:
> Each query is running in a separate transaction.

Interesting.  You might also compile with CATCACHE_STATS (and not CATCACHE_FORCE_RELEASE, or perhaps with and without)
andthen check out your logs after the process ends (you might need to increase the logging level to DEBUG2 if you don't
seeanything initially). 

> Why does portioning is done better rather than using partial index?

There's a couple of reasons, but for one thing, you can do parallel loading of data into partitioned tables
(particularlyif you refer to the individual partitions directly rather than going through the top-level table with a
triggeror similar).  Trying to parallel load into one table with 500 indexes would be pretty painful, I expect. 
Thanks,
    Stephen