Re: [PERFORM] update from performance question

Hi Albe Thank you for your reply The query changed a bit explain (analyze, buffers) UPDATE csischema.tf_transaction_item_person TRANS SET general_ledger_code = PURCH.general_ledger_code, general_ledger_code_desc = PURCH.general_ledger_code_desc, update_datetime = now()::timest

[PERFORM] update from performance question

Hi Running 9.5.2 I have the following update and run into a bit of a trouble . I realize the tables involved have quite some data but here goes UPDATE tf_transaction_item_person TRANS SET general_ledger_code = PURCH.general_ledger_code, general_ledger_code_desc = PURCH.general_led