An Inesrt on a partitioned table become very slow

Tomer Praizler <[email protected]>
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <CAD=kdR9rs+3+NrfTAdA_8gaPfXQg5gt06F_Ddz4dY-WZcOLd5g@mail.gmail.com>
Hey,

I use Postgres 10.1, and I have the following structure:
Parent table with columns:
range_value: double, timestamp: timestamp, device_id: integer, count:integer

which is partitioned with Partition key: LIST (range_value) which has a
value of 1 - 26.
So basically it has 26 child partitions.

Each one of those partitions it partitioned by range. essentially a daily
partition.

This is how the perant_table_with_range_value_1 is conofigured:

Partition of: perant_table FOR VALUES IN ('1')
Partition constraint: ((range_value IS NOT NULL) AND (range_value = ANY
(ARRAY['0'::double precision])))
Partition key: RANGE ("timestamp")

At the moment I have 128 days of partitions in each one of the ranged
partitioned.
Which means a total of 26 * 128 = 3328 total partitions.

My problem is that inserts became very slow.
I used to bulk insert 10000 rows in 6 seconds, now it takes 45 seconds.

Is this an expected behavior? is there something I missing?
Thank you!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.