[PERFORM] Partitioning perfomance issue

2017-09-17 Thread Konstantin Kivi
I tried to use partitioning and have problem with it, as I get very bad perfomance. I cannot understand, what I am doing wrong. I set up master and child tables via inheritance, with range CHECK by date and with trigger on 'insert', as described in the documentation. I was happy with insertion s

[PERFORM] Poor perfomance of update (and select) on partitioned tables

2017-09-07 Thread Konstantin Kivi
Hello Trying to setup table partitioning I noticed strange behavior that prevents me from using it. I set up master and child tables via inheritance, with range CHECK by date and with trigger on 'insert', as described in the documentation. I was happy with insertion speed, it was about 30 megaby