Loading...

XML

Word

Printable

Type: Quality Risk
Resolution: Done
Priority: Major
Fix Version/s: 11.1.2, 12.0, 11.2.1
Affects Version/s: None
Component/s: ODBC
Labels:
None

Forum Reference:
https://developer.jboss.org/message/986242

For a large number of tables/columns the query for pg_index takes an inordinate amount of time to complete - for releases after 10.1.1 this will happen only for the initial load.

The structure of the query should be improved as well as a managed materialization load to better ensure that it does not block a user query.

is related to

TEIID-5532 Common table projection minimization does not account for usage in a subquery nested in an aggregate or in some view scenarios

Resolved

relates to

TEIID-5529 Non-pushed subquery may have evaluatable predicates not pushed

Resolved

TEIID-5531 Implicit indexing of common tables doesn't consider composite keys

Resolved

Assignee:: Steven Hawkins

Reporter:: Steven Hawkins

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 2018/11/07 6:35 PM

Updated:: 2018/11/09 4:49 PM

Resolved:: 2018/11/09 4:49 PM

Details

Description

Attachments

Issue Links

Activity

People

Dates