View Single Post

   
  #6 (permalink)  
Old 04-10-2008, 10:14 AM
Tom Lane
 
Posts: n/a
Default Re: Out of memory error during large hashagg

Casey Duncan <casey@pandora.com> writes:
> seed | st_id | 164656


> I ran analyze after this, but the results were roughly the same.


What's the statistics target set to, and did you try increasing it?
Can we see the rest of the pg_stats row for this column (I'm mainly
interested in the most-common-value frequencies)?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote