Re: Query Performance / Planner estimate off

2020-10-20 Thread Sushant Pawar
Looping in the main group ID. Regards Sushant On Tue, Oct 20, 2020 at 6:49 PM Sushant Pawar wrote: > > On Tue, Oct 20, 2020 at 3:08 PM Mats Julian Olsen > wrote: > >> Dear Postgres community, >> >> I'm looking for some help to manage queries against two lar

Re: Too many waits on extension of relation

2020-10-05 Thread Sushant Pawar
indication that 12-13GB shared_buffers would be appropriate in our case. I have used the below URL to evaluate the shared buffer sizing. https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/ Best Regards, *Sushant Pawar * On Mon, Oct 5, 2020 at 10:14 PM Michael Lewis