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
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
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
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