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
Armand Pirvu wrote:
> 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,
> gener