Postgres Pro
Downloads
Home   >   mailing lists

Re: Hash Aggregate plan picked for very large table == out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: Hash Aggregate plan picked for very large table == out of memory
Date
Msg-id 20377.1181854511@sss.pgh.pa.us
Whole thread Raw
In response to Hash Aggregate plan picked for very large table == out of memory  ("Mason Hale" <masonhale@gmail.com>)
Responses Re: Hash Aggregate plan picked for very large table == out of memory  ("Mason Hale" <masonhale@gmail.com>)
List pgsql-general
Tree view 
"Mason Hale" <masonhale@gmail.com> writes:
> SELECT target_page_id, min(created_at)
> FROM page_page_link
> GROUP BY 1;

> The page_page_link table has ~130 million rows.

> After analyzing the table, the planner picks a hash aggregate plan, which
> results in an out of memory error.

What have you got work_mem set to?  What's the actual number of groups
(target_page_id values)?

            regards, tom lane

pgsql-general by date:

Previous
From: Rodrigo De León
Date:
Subject: Re: Historical Data Question
Next
From: "Mason Hale"
Date:
Subject: Re: Hash Aggregate plan picked for very large table == out of memory