Re: select count() out of memory

From: tfinneid(at)student(dot)matnat(dot)uio(dot)no
To: "Erik Jones" <erik(at)myemma(dot)com>
Cc: tfinneid(at)student(dot)matnat(dot)uio(dot)no, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Gregory Stark" <stark(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: select count() out of memory
Date: 2007-10-25 15:58:16
Message-ID: 46316.134.32.140.234.1193327896.squirrel@webmail.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Excellent, it sounds like you should be fine then. One thing to
> note: if you want to get an "idea" of how many rows you have in your
> partitions, you can run a SUM aggregate on reltuples in pg_class for
> all of your partitions. The more recent the last ANALYZE for each
> table, the more accurate those values will be.

cool, thanks.

regards

thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2007-10-25 16:02:51 Re: subversion support?
Previous Message tfinneid 2007-10-25 15:56:21 Re: select count() out of memory