Performance regression related to parallel execution

2019-03-11 Thread Jinho Jung
Hello, We noticed that the following SQL queries are running 3 times slower on the latest version of PostgreSQL. Here’s the time taken to execute them on older (v9.5.16) and newer versions (v11.2) of PostgreSQL (in milliseconds): +---++-+-+---+

Shared_buffers

2019-03-11 Thread Daulat Ram
Hi team, I want to know about the working and importance of shared_buffers in Postgresql? is it similar to the oracle database buffer cache? Regards, Daulat