Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE ADD COLUMN fast default - Mailing list pgsql-hackers

From David Rowley
Subject Re: ALTER TABLE ADD COLUMN fast default
Date
Msg-id CAKJS1f-oW14tJB8iytaND5CJO8kF9gtUQrEc9Unn+g-zuDJPLw@mail.gmail.com
Whole thread Raw
In response to Re: ALTER TABLE ADD COLUMN fast default  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Responses Re: ALTER TABLE ADD COLUMN fast default  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On 14 March 2018 at 11:36, Andrew Dunstan
<andrew.dunstan@2ndquadrant.com> wrote:
> Here are the benchmark results from the v15 patch. Fairly similar to
> previous results. I'm going to run some profiling again to see if I
> can identify any glaring hotspots. I do suspect that the "physical
> tlist" optimization sometimes turns out not to be one. It seems
> perverse to be able to improve a query's performance by dropping a
> column.

Can you explain what "fdnmiss" is that appears in the results?


-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: ExplainProperty* and units
Next
From: Andres Freund
Date:
Subject: Re: ALTER TABLE ADD COLUMN fast default