Re: select count() out of memory

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: tfinneid(at)student(dot)matnat(dot)uio(dot)no
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: select count() out of memory
Date: 2007-10-25 12:19:02
Message-ID: 20071025121902.GC5661@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

tfinneid(at)student(dot)matnat(dot)uio(dot)no wrote:

> > are a dump of Postgres's current memory allocations and could be useful in
> > showing if there's a memory leak causing this.
>
> The file is 20M, these are the last lines: (the first line continues
> unttill ff_26000)
>
>
> idx_attributes_g1_seq_1_ff_4_value7: 1024 total in 1 blocks; 392 free (0
> chunks); 632 used

You have 26000 partitions???

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tfinneid 2007-10-25 12:21:17 Re: select count() out of memory
Previous Message tfinneid 2007-10-25 12:16:50 Re: select count() out of memory