Re: Out of memory

Hi Jeff,

< Where is the source to the function? 

The source is located here: https://github.com/linz/linz_bde_uploader

The main function LDS_MaintainSimplifiedLayers that is being called is on line 37 is in
https://github.com/linz/linz_bde_uploader/blob/master/sql/lds_layer_functions.sql. 

The actual out of memory exception was caught with the bde_GetTableDifferences function source file on line 3263 in
https://github.com/linz/linz_bde_uploader/blob/master/sql/bde_control_functions.sql.

When I was actually getting an out of memory issue when creating the tables (not maintaining them), the query that
seemedto kill the transaction was the one located at line 1463 of
https://github.com/linz/linz_bde_uploader/blob/master/sql/lds_layer_functions.sql.After I dropped the work_mem to 1MB
itgot past that and completed ok. But during the maintenance of the table the row differences need to be calculated and
thenapplied to the table. See the LDS_ApplyTableDifferences function on line 353. 

Regards,
Jeremy
______________________________________________________________________________________________________

This message contains information, which is confidential and may be subject to legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info@linz.govt.nz) and
destroythe original message. 
LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.

Thank you.
______________________________________________________________________________________________________