Re: Bad query plan when you add many OR conditions

Marco Colli schrieb am 10.01.2020 um 02:11: > I have a query on a large table that is very fast (0s): > https://gist.github.com/collimarco/039412b4fe0dcf39955888f96eff29db#file-fast_query-txt > > Basically the query matches the rows that have a tag1 OR tag2 OR tag3 OR tag4 > OR tag5...  > > Howe

shared buffers and startup process

Hi, I have a master slave setup with streaming replication. I have a lots of wal files that were moved from master but not applied yet , a big delay in the replica. The replica is not working on hotstandby mode , no conflicts to delay wals apply on it. I would like to know if increasing the am

Re: shared buffers and startup process

On Tue, Jan 14, 2020 at 04:29:51PM +0100, Joao Junior wrote: > I would like to know if increasing the amount of shared-buffers could help > the startup process applying the wals. I would like to know if in > the process of reading the wals and applying them, blocks that should be > written will b