3 ms·

I don't _think_ the query planner takes "current load" into account. If you have: - Same resources (CPU/memory) - Same settings (eg work_mem, amongst others)

I don't _think_ the query planner takes "current load" into account. If you have: - Same resources (CPU/memory) - Same settings (eg work_mem, amongst others) - Same dataset - Same/similar statistics (gathered with ANALYZE or the autovacuum) you should get the same results. If I'm wrong, please somebody correct me!

jaggederest 4y ago
You might be right, definitely if you run e.g. a fully cloned server on the same disk image and hardware it will behave the same, I'm thinking of times when memory pressure on the database from other queries caused caches to get evicted, things like that. It's not really the planner, it's the measured performance from lock contention and the data in memory etc.