3 ms·
In my experience, without careful tunning, postgres performance starts dropping significantly around 10 million rows.
by feverzsj 2y ago
In my experience, without careful tunning, postgres performance starts dropping significantly around 10 million rows.
- szundi 2y agoWe have billions of rows with clustering on one instance, perfect, half a rack almost.
- natmaka 2y agoWithout any consideration for I/O? In my experience performance is often directly related to the ratio (total RAM available to Postgresql, shared buffer and buffercache included / total size of tables and indices ), save any weird usage pattern.
- boomskats 2y agoCould you tell us a bit more about your experience?