Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6186: out of memory while analyze - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6186: out of memory while analyze
Date
Msg-id 25153.1314732080@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6186: out of memory while analyze  ("Lampa" <lampacz@gmail.com>)
Responses Re: BUG #6186: out of memory while analyze
List pgsql-bugs
Tree view 
"Lampa" <lampacz@gmail.com> writes:
> Trying analyze table (ANALYZE TABLE table or VACUUM ANALYZE table) with
> 3051316 rows (displayed size 2521MB in \dt+)

What have you got maintenance_work_mem set to?  shared_buffers might
also be interesting.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #6186: out of memory while analyze
Next
From: Isaac Jurado
Date:
Subject: Re: BUG #6185: Segmentation fault with NULL string columns