Re: Need to know more about pg_test_fsync utility

2021-12-12 Thread PGSQL DBA
Hi Thomas, Apologies for uploading the wrong screenshot in the attachment. I have uploaded the correct output of pg_test_fsync for your reference . Please find our environment details as below: Infra: Azure IaaS OS: Red Hat Enterprise Linux Server release 7.9 File System: XFS Disk: Premium SSD IO

Re: Need to know more about pg_test_fsync utility

2021-12-12 Thread Thomas Munro
On Mon, Dec 13, 2021 at 3:04 PM PGSQL DBA wrote: > As you mentioned in question-8, "I'd investigate whether data is being cached > unexpectedly, perhaps indicating that committed transactions be lost in a > system crash event." So, I would like to know that if we configure the disk > for the WA

Re: Advice on using materialized views

2021-12-12 Thread Wicher
On Thu, 09 Dec 2021 16:06:27 + "Phil Endecott" wrote: > Thanks both for your replies. > > Wicher wrote: > > On Mon, 06 Dec 2021 18:48:47 + > > "Phil Endecott" wrote: > >> and > >> I need to modify the definition of a view that filters the "new" > >> values from the raw table each ti