Re: lwlock:LockManager wait_events

2024-10-25 Thread SAMEER KUMAR
On Fri, 25 Oct 2024, 14:36 James Pang, wrote: > experts, > we faced into a lot of lwlock:LockManager wait-events , all of these > queries are "select ..." , there are other several session are doing DML, > insert/update/delete on same table. Did these DML transactions holding > "transacti

Re: Identify root-cause for intermittent spikes

2022-10-11 Thread SAMEER KUMAR
On Tue, 11 Oct 2022, 22:07 Sengottaiyan T, wrote: > Hi All, >> >> I'm looking for suggestions: >> >> Environment: AWS PostgreSQL RDS instance - Version 14.3 >> Operations support gets intermittent alerts from the monitoring tool >> through AWS cloud watch metrics on Disk Queue Depth, CPU burst-cr

Re: LIMIT OFFSET with DB view vs plain SQL

2019-04-01 Thread SAMEER KUMAR
Thanks, Sameer +65 81100350 *Please consider the environment before printing this e-mail!* On Mon, Apr 1, 2019 at 9:57 PM Raj Gandhi wrote: > Any other idea how to resolve the performance issue with the database view? > > On Fri, Mar 29, 2019 at 7:38 PM Raj Gandhi wrote: > >> Merlin, I tried