From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Edmund Dengler <edmundd(at)eSentire(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] INHERITS and planning |
Date: | 2005-06-16 08:07:32 |
Message-ID: | 1118909252.3645.197.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Thu, 2005-06-16 at 12:59 +0800, Christopher Kings-Lynne wrote:
> > Well, it's not so much that I care about queries with 1000+ relations,
> > as that this is a good way to stress-test the code and find out where
> > the performance issues are. There are many thousand lines of code that
> > can never be performance-sensitive, but to expose the ones that are
> > it helps to push the envelope a bit.
>
> Once we have partitioning and people set up automated scripts to
> partition off stuff, we may well end up with 1000+ table queries...
I can see why you think that, but there will always be pressure to
reduce the number of partitions for a variety of reasons. IMHO that will
lead to an optimum range of values.
To me, it seems likely there would be a recommendation along the lines
of: divide the table up naturally in a way that gives between 10 and 500
partitions that are mostly roughly equally sized.
Using more than that could lead to some fairly strange designs.
Anyway, lets wait and see.
Best Regards, Simon Riggs
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2005-06-16 08:10:24 | Re: PostgreSQL Certification |
Previous Message | Danny Gaethofs | 2005-06-16 07:26:07 | Could not open service manager |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2005-06-16 08:18:00 | PROPOSAL - User's exception in PL/pgSQL |
Previous Message | Simon Riggs | 2005-06-16 06:52:00 | Re: [HACKERS] INHERITS and planning |