From: | tfinneid(at)student(dot)matnat(dot)uio(dot)no |
---|---|
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:50:45 |
Message-ID: | 46056.134.32.140.234.1193327445.squirrel@webmail.uio.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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.
That means I am exploring new territory, which is good. Of course, there
is a possibility the design could be done in a different way so as not to
need that many partitions. But I asked on this list a some of months ago
about tips on how to design this data model and what I came up with was
what I have today.
The problem is the work is proprietary and confidential, so its difficult
for me to explain in detail what I want to do. But you could look at my
previous post asking the question for the descriptions of the problem I
want to solve.
regards
thomas
From | Date | Subject | |
---|---|---|---|
Next Message | tfinneid | 2007-10-25 15:56:21 | Re: select count() out of memory |
Previous Message | tfinneid | 2007-10-25 15:45:38 | Re: select count() out of memory |