ind of materialize plan in explain
Any other ideas I can do for window based joins.
--yr
On Fri, Jul 31, 2015 at 11:37 AM, Qingqing Zhou
wrote:
> On Fri, Jul 31, 2015 at 10:55 AM, Ram N wrote:
> >
> > Thanks Qingqing for responding. That didn't help. It in fact increa
ot
of time. Increase work_mem has helped in reducing the processing time but
it's still > 1 min.
--yr
On Thu, Jul 30, 2015 at 1:24 PM, Qingqing Zhou
wrote:
> On Thu, Jul 30, 2015 at 12:51 AM, Ram N wrote:
> > " -> Index Scan using end_date_idx on
Hi,
I am trying to see if I can do anything to optimize the following plan.
I have two tables and I am doing a join between them. After joining it
calculates aggregates (Sum and Count)
Table 1 : timestamp (one per day) for 2 years (730 records)
Table 2 : Window based validity records. Window here
