Re: Partitioning / Clustering - Mailing list pgsql-performance

From Alex Stapleton
Subject Re: Partitioning / Clustering
Date
Msg-id CFF798C9-3996-4B99-B3D4-B8B90589E912@advfn.com
Whole thread Raw
In response to Re: Partitioning / Clustering  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Partitioning / Clustering
Re: Partitioning / Clustering
List pgsql-performance
On 11 May 2005, at 08:16, Simon Riggs wrote:

> On Tue, 2005-05-10 at 11:03 +0100, Alex Stapleton wrote:
>
>> So, when/is PG meant to be getting a decent partitioning system?
>>
>
> ISTM that your question seems to confuse where code comes from.
> Without
> meaning to pick on you, or reply rudely, I'd like to explore that
> question. Perhaps it should be a FAQ entry.
>
> All code is written by someone, and those people need to eat. Some
> people are fully or partly funded to perform their tasks on this
> project
> (coding, patching, etc). Others contribute their time for a variety of
> reasons where involvement has a positive benefit.
>
> You should ask these questions:
> - Is anyone currently working on (Feature X)?
> - If not, Can I do it myself?
> - If not, and I still want it, can I fund someone else to build it for
> me?
>
> Asking "when is Feature X going to happen" is almost certainly
> going to
> get the answer "never" otherwise, if the initial development is large
> and complex. There are many TODO items that have lain untouched for
> years, even though adding the feature has been discussed and agreed.
>
> Best Regards, Simon Riggs
>

Acceptable Answers to 'So, when/is PG meant to be getting a decent
partitioning system?':

     1. Person X is working on it I believe.
     2. It's on the list, but nobody has done anything about it yet
     3. Your welcome to take a stab at it, I expect the community
would support your efforts as well.
     4. If you have a huge pile of money you could probably buy the
Moon. Thinking along those lines, you can probably pay someone to
write it for you.
     5. It's a stupid idea, and it's never going to work, and heres
why..............

Unacceptable Answers to the same question:

     1. Yours.

Be more helpful, and less arrogant please. Everyone else who has
contributed to this thread has been very helpful in clarifying the
state of affairs and pointing out what work is and isn't being done,
and alternatives to just waiting for PG do it for you.

>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>


pgsql-performance by date:

Previous
From: "Edin Kadribasic"
Date:
Subject: Optimizer wrongly picks Nested Loop Left Join
Next
From: Alex Stapleton
Date:
Subject: Re: Partitioning / Clustering