Hi,
> We modify the following macro definition:
> NUM_BUFFER_PARTITIONS 1024
> LOG2_NUM_PREDICATELOCK_PARTITIONS 10
> LOG2_NUM_LOCK_PARTITIONS 10
IME, increase in NUM_BUFFER_PARTITIONS is effective but that in
LOG2_NUM_LOCK_PARTITIONS results in performance degradation. Probably
because it leads
Hello there,
I use PostgreSQL 9.1
The scenario is:
I receive heavy insertion into Table1 (about 100 rows a sec). For
each new entry, I have to check it with the previous and next ones
(check if those items are inside an area using ST_DWithin). Depending on
the result, what I need to do is: u
We use benchmarksql to start tpcc test in postgresql 9.3.3.
Before test we set benchmarksql client number about 800. And we increase the
hash partitions from 16 to 1024 , in order to reduce the hash partition locks
competition.
We expect that after increase the number of partitions, reduces lock
