Re: select count() out of memory - Mailing list pgsql-general

From tfinneid@student.matnat.uio.no
Subject Re: select count() out of memory
Date
Msg-id 46316.134.32.140.234.1193327896.squirrel@webmail.uio.no
Whole thread Raw
In response to Re: select count() out of memory  (Erik Jones <erik@myemma.com>)
List 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


pgsql-general by date:

Previous
From: tfinneid@student.matnat.uio.no
Date:
Subject: Re: select count() out of memory
Next
From: Tino Wildenhain
Date:
Subject: Re: subversion support?