Re: tableam vs. TOAST - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: tableam vs. TOAST
Date
Msg-id CAE9k0PmqKnFR68axmpq0MZ2GTKPe+bhX3ApMuqq8UYD4egAUFQ@mail.gmail.com
Whole thread Raw
In response to Re: tableam vs. TOAST  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Hi Craig,

Please find my response inline below.

On Sun, Nov 10, 2019 at 2:39 PM Craig Ringer <craig@2ndquadrant.com> wrote:
>
> On Thu, 7 Nov 2019 at 22:45, Ashutosh Sharma <ashu.coek88@gmail.com> wrote:
>>
>
> In fact, I suspect this is PostgreSQL successfully protecting itself from an unsafe situation.
>
> Does the host have thin-provisioned storage? lvmthin, thin-provisioned SAN, etc?
>

No, It doesn't. Infact the machine on which the issue was reproduced
once/twice doesn't have any LVMs. The other machine on which the issue
never got reproduced have some LVMs but they are thick-provisioned not
thin-provisioned.

> Is the DB on NFS?
>

No.

--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: cost based vacuum (parallel)
Next
From: Dilip Kumar
Date:
Subject: Re: [HACKERS] Block level parallel vacuum