4 ms·
What stood out to me was that the measurement was taken against 20 tables. That makes me wonder if a smaller number of tables would have hit contention even in
by arielweisberg 11y ago
What stood out to me was that the measurement was taken against 20 tables.
That makes me wonder if a smaller number of tables would have hit contention even in a read only workload.
Well it's not the only database that has this problem. I wonder if partitioning is enough or if you really need separate tables.
- hyperpape 11y ago"The data set is 1 million rows in 20 tables. Fewer tables can be used, but below 4 tables the performance drops somewhat due to a hot spot in the table definition cache."