Examples of Atypical Scenarios in PostgreSQL Load Testing

PostgreSQL is a popular OLTP database that can achieve millions of transactions per second with SELECT/DML queries. During the talk, the speaker will cover atypical workloads, provide examples and analyze them using profiling. We will discuss why COMMIT may be slow, what are the pitfalls of creating one million tables, how one can connect fast and why cannot do it faster.