Leonardo F <m_lists@xxxxxxxx> writes: > I have a simple table that has indexes on 2 integer columns. > Data is inserted very often (no updates, no deletes, just inserts): > at least 4000/5000 rows per second. > The input for the 2 indexed columns is very random. > Everything is "fine" for the first 10-20M rows; after that, performance > gets worse and worse, and by 50M rows I can't insert more than > 1500 rows per second. > How can I improve it? Does it help to reindex the index at that point? > 1) the table is already partitioned; at the moment it's based on > 30 partitions. What kind of "select" performance impact would I > hit going to 3000 partitions? Bad. The partitioning code isn't designed to scale beyond a few dozen partitions. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
