Re: PostgreSQL Process memory architecture

* Ben Zeev, Lior (lior(dot)ben-zeev(at)hp(dot)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) and then check out
your logs after the process ends (you might need to increase the logging
level to DEBUG2 if you don't see anything 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 (particularly if you refer to
the individual partitions directly rather than going through the
top-level table with a trigger or similar). Trying to parallel load
into one table with 500 indexes would be pretty painful, I expect.

Thanks,

Stephen