>> Cons >> ----------- >> 1. Deletes can be somewhat expensive. >> 2. Transaction aborts will be expensive. >> 3. Updates that update most of the indexed columns can be somewhat expensive.
Given transaction aborts are expensive, is there any impact on the crash recovery? Did you perform any tests on the recovery duration? Thanks, Satya ________________________________ From: Amit Kapila <amit.kapil...@gmail.com> Sent: Thursday, March 1, 2018 7:05:12 AM To: PostgreSQL Hackers Subject: Re: zheap: a new storage format for PostgreSQL On Thu, Mar 1, 2018 at 7:39 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > > Preliminary performance results > ------------------------------------------- > I have not used plain text mode in my previous email due to which performance results might not be clear in some email clients, so attaching it again in the form of pdf. -- With Regards, Amit Kapila. EnterpriseDB: https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.enterprisedb.com&data=04%7C01%7CSatyanarayana.Narlapuram%40microsoft.com%7Cad676656345544116aa008d57f85e87d%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636555135932006655%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwifQ%3D%3D%7C-1&sdata=7z7XUUdXr3CZe71y%2F7kVto%2BzJB5IogypcRHODu8yAu0%3D&reserved=0
