RE: [EXT] Re: Read-only connectios optimizatios

2025-01-27 Thread Wong, Kam Fook (TR Technology)
Just a thought if you are moving to AWS Aurora Postgres. You can point the read queries/transaction/long running read queries to the reader node. That will not block the autovacuum process. -Original Message- From: peter plachta Sent: Saturday, January 25, 2025 4:12 PM To: Laurenz

Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux

2025-01-27 Thread Laurenz Albe
On Mon, 2025-01-27 at 12:29 +, Praveen Kumar Mandula wrote: > Attaching linux and windows logs, are they useful in identifying why its > taking time more in windows ? No. I told you what to investigate, right? Yours, Laurenz Albe

Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE

2025-01-27 Thread Feike Steenbergen
On Thu, 9 Jan 2025 at 20:39, Tom Lane wrote: > Yeah. That prevents pushing down the join condition, since in a FULL join all > rows of both sides will contribute to the result; none can be removed ahead of > the join. > Not sure if this pattern is common enough to be worth trying to implement su

Re: Reg pg_restore taking more time in windows compare to linux

2025-01-27 Thread Laurenz Albe
On Sun, 2025-01-26 at 07:14 +, Praveen Kumar Mandula wrote: > For one of our customer, when they are restoring DB, its taking more time. > In Windows its taking around 43 hours, where as in Linux its taking around 3 > hours. Check if the problem is caused by lame hardware. Other than that, a