search

sraoss / pg_ivm

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Other
994 stars 27 forks source link

update on related table #63

Open sasog23 opened 1 year ago

sasog23 commented 1 year ago

if I update the table global.organizations it takes more than 10s is this normal behaviour ?

SELECT create_immv('servicedesk.hd_677533', ' SELECT h.id, h.created_at, h.updated_at, h.organization_id , h.customer_id, cust.short_name AS "customer_name" from servicedesk.helpdesk h JOIN global.organizations cust on cust.id= h.customer_id WHERE h.organization_id= 677533 ');

yugo-n commented 1 year ago

Could you share your definition of tables and indexes, and the query you used to update a table?

yugo-n commented 1 year ago

In addition, it would be helpful if you could share the result of explain (analyze, verbose) of the udpate query because this contains the execution times of triggers that perform the actual view maintenance.