Comment 3 for bug 810104

Revision history for this message
Robert Collins (lifeless) wrote :

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.