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

From Alvaro Herrera
Subject Re: select count() out of memory
Date
Msg-id 20071025153521.GC23566@alvh.no-ip.org
Whole thread Raw
In response to Re: select count() out of memory  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe escribió:

> So, out of curiosity, I asked my Oracle DBA friend if she'd ever heard
> of anyone having 60,000 or so partitions in a table, and she looked at
> me like I had a third eye in my forehead and said in her sweet voice
> "Well, that would certainly be an edge case".  She sounded like she
> was worried about me.

Did you get rid of that third eye already?  I would be equally worried.

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude."                              (Brian Kernighan)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: select count() out of memory
Next
From: tfinneid@student.matnat.uio.no
Date:
Subject: Re: select count() out of memory