Project:
View Revisions: Issue #38291 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0038291: Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data | ||
Revision | 2018-04-06 14:52 by shuehner | ||
Description | Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data. The problem happens when there are lot of records in OBEDL_REQUEST_LINE table that has a foreign key to C_IMPORT_ENTRY_ARCHIVE. Same issue can happen with C_IMPORT_ENTRY_ID column. (In ImportEntryArchiveThread as it deletes from c_import_entry table triggering same seq-scan) -> Already visible with 500ms avg time of pgbadger for delete of c_import_entry probably coming from that (2nd indicator is very high number of seq-scans of obedl_request_line table) |
||
Revision | 2018-04-06 14:52 by shuehner | ||
Description | Log Clean Up process doesn't finish deleting C_IMPORT_ENTRY_ARCHIVE table with big amount of data. The problem happens when there are lot of records in OBEDL_REQUEST_LINE table that has a foreign key to C_IMPORT_ENTRY_ARCHIVE. Same issue can happen with C_IMPORT_ENTRY_ID column. |
Copyright © 2000 - 2009 MantisBT Group |