Bug 1257011
Summary: | Investigate why some custom field types are slow to create under PostgreSQL | ||
---|---|---|---|
Product: | [Community] Bugzilla | Reporter: | Jason McDonald <jmcdonal> |
Component: | Database | Assignee: | Jeff Fearn 🐞 <jfearn> |
Status: | CLOSED CANTFIX | QA Contact: | Rony Gong 🔥 <qgong> |
Severity: | medium | Docs Contact: | |
Priority: | medium | ||
Version: | 4.4 | CC: | jmcdonal, mtahir, qgong |
Target Milestone: | 4.4 | ||
Target Release: | --- | ||
Hardware: | Unspecified | ||
OS: | Unspecified | ||
Whiteboard: | |||
Fixed In Version: | Doc Type: | Bug Fix | |
Doc Text: | Story Points: | --- | |
Clone Of: | Environment: | ||
Last Closed: | 2015-09-01 22:33:33 UTC | Type: | Bug |
Regression: | --- | Mount Type: | --- |
Documentation: | --- | CRM: | |
Verified Versions: | Category: | --- | |
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
Cloudforms Team: | --- | Target Upstream Version: | |
Embargoed: |
Description
Jason McDonald
2015-08-26 05:07:58 UTC
I don't think this is related to Bugzilla code, it's just how Postgres does it's thing. e.g. code BZ generates run by hand in Pg: bugs=# ALTER TABLE bugs ADD COLUMN cf_ft_test_21 varchar(255) DEFAULT '' NOT NULL; ALTER TABLE Time: 194470.637 ms You could save some time in creation by dropping the constraints, but it'd break the code in a lot of places, and still isn't fast enough for production use. bugs=# ALTER TABLE bugs ADD COLUMN cf_ft_test_22 varchar(255); ALTER TABLE Time: 84641.213 ms There is nothing fancy or complex in the BZ code, it's just a DBMS limitation on updating huge tables. Is there anything else you'd like covered? |