Re: Getting an out of memory failure.... (long email)

Sean Shanny <shannyconsulting@earthlink.net> writes:
>                     ->  Seq Scan on f_pageviews t1  (cost=0.00..11762857.88
> rows=1 width=8)
>                           Filter: ((date_key >= 610) AND (date_key <= 631))

How many rows are actually going to match that filter condition?  (The
symptoms seem to indicate that the answer is "a whole lot", not "1".)

I speculate that you're overdue for an ANALYZE on this table, and that
the planner thinks this scan is going to yield no rows because the
stats it has say there are no rows with date_key >= 610.

            regards, tom lane