2 ms·
Postgres can operate over transaction DDL but in most cases I think this would be a fine thing to isolate over - the more worrying case is when different transa
by munk-a 7y ago
Postgres can operate over transaction DDL but in most cases I think this would be a fine thing to isolate over - the more worrying case is when different transaction spaces have different understandings of row statistics - PG does use row statistics to inform planning so it's not inconceivable that sharing a plan between two queries running in vastly different data states would result in a highly inefficient query.
- SigmundA 7y agoMSSQL does this as well, it will evict plans based on significant statistic changes and does parameter sniffing to decide on reusing a plan.