cold, on qastaging with 600 summary changes: lpmain_staging=# select count(*) from bugsummaryjournal; count ------- 603 (1 row)
lpmain_staging=# explain analyze select bugsummary_rollup_journal(); QUERY PLAN ------------------------------------------------------------------------------------------ Result (cost=0.00..0.26 rows=1 width=0) (actual time=8543.085..8543.086 rows=1 loops=1) Total runtime: 8543.112 ms (2 rows)
lpmain_staging=# select count(*) from bugsummaryjournal; count ------- 0
so its at least working, though whether it fixes the performance issue I'm not sure.
cold, on qastaging with 600 summary changes:
lpmain_staging=# select count(*) from bugsummaryjournal;
count
-------
603
(1 row)
lpmain_staging=# explain analyze select bugsummary_ rollup_ journal( );
QUERY PLAN ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------ 085..8543. 086 rows=1 loops=1)
-------
Result (cost=0.00..0.26 rows=1 width=0) (actual time=8543.
Total runtime: 8543.112 ms
(2 rows)
lpmain_staging=# select count(*) from bugsummaryjournal;
count
-------
0
so its at least working, though whether it fixes the performance issue I'm not sure.