Strange runtime partition pruning behaviour with 11.4

2019-08-02 Thread Thomas Kellerer
I stumbled across this question on SO: https://stackoverflow.com/questions/56517852 Disregarding the part about Postgres 9.3, the example for Postgres 11 looks a bit confusing. There is a script to setup test data in that question: start of script create table foo ( fo

Re: PSQL performance - TPS

2019-08-02 Thread Imre Samu
> Application as a whole is expected to give an throughput of 100k transactions per sec. > On this env(8core cpu, 16GB) what is the TPS that we can expect? as a reference - maybe you can reuse/adapt the "TechEmpower Framework Benchmarks" tests - and compare your PG9.6+hardware results. The new T