Re: select count() out of memory

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "tfinneid(at)student(dot)matnat(dot)uio(dot)no" <tfinneid(at)student(dot)matnat(dot)uio(dot)no>, pgsql-general(at)postgresql(dot)org
Subject: Re: select count() out of memory
Date: 2007-10-25 15:35:21
Message-ID: 20071025153521.GC23566@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tfinneid 2007-10-25 15:36:09 Re: select count() out of memory
Previous Message Alvaro Herrera 2007-10-25 15:32:25 Re: select count() out of memory