0040131: Set two new columns in C_Invoice as nullable and do not set a default value

Description

In Create Lines From Refactor introduced in 18Q4, two new columns were added to C_Invoice table: CREATEFROMORDERS and CREATEFROMINOUTS.

They were set as mandatory and default value 'N'.

In versions before PG 11 this configuration adds an important overhead when creating the columns. So to avoid a performance issue in the update process, it would be better to set both columns as nullable and without a default value.

Basically is to revert the changeset: https://code.openbravo.com/erp/devel/pi/rev/7d6426933ab5 [^]

Steps To Reproduce

In a HV table, like c_order, run:
ALTER TABLE c_order add COLUMN test character varying(1) default 'N';
Check it's very slow.

Now run:
ALTER TABLE c_order add COLUMN test2 character varying(1);
It's almost immediate.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0040119

closed

AtulOpenbravo

Set two new columns in C_Invoice as nullable and do not set a default value

Notes
(0109789) Sandrahuguet (developer) 2019-02-13 09:02	Create lines from refactor is introduced in 18Q4

Issue History
Date Modified	Username	Field	Change
2019-02-04 20:10	AtulOpenbravo	Type	defect => backport
2019-02-04 20:10	AtulOpenbravo	Target Version	=> 3.0PR18Q3.5
2019-02-13 09:02	Sandrahuguet	Review Assigned To	=> Sandrahuguet
2019-02-13 09:02	Sandrahuguet	Note Added: 0109789
2019-02-13 09:02	Sandrahuguet	Status	scheduled => closed
2019-02-13 09:02	Sandrahuguet	Resolution	open => invalid