Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Necati Batur
Hi all, I am new at open source project however in a user point of view I must confess that usability is a really though issue ,even if the performance of a database is crucial. As to my idea for improve postgresql is ; http://www.postgresql.org/docs/current/interactive/ddl-partitioning.html in

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Robert Haas
On Fri, Apr 9, 2010 at 9:10 AM, Necati Batur necatiba...@gmail.com wrote: I am new at open source project however in a user point of view I must confess that usability is a really though issue ,even if the performance of a database is crucial. Sure. Nobody is saying otherwise. As to my idea

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Necati Batur
Hi, All I want to contribute to the project a liitle. I do not claim that I can actually solve all the issues about partitioning. Of course there are lots of ideas ,some looks pretty easy however, the distribution issue seems too attractive to me that I am dying to work on. I have checked the

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Alvaro Herrera
Necati Batur escribió: Hi, All I want to contribute to the project a liitle. I do not claim that I can actually solve all the issues about partitioning. Of course there are lots of ideas ,some looks pretty easy however, the distribution issue seems too attractive to me that I am dying to work

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Dimitri Fontaine
Alvaro Herrera alvhe...@commandprompt.com writes: Necati Batur escribió: Hi, All I want to contribute to the project a liitle. I do not claim that I can actually solve all the issues about partitioning. Of course there are lots of ideas ,some looks pretty easy however, the distribution issue

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Necati Batur
Well, If the project criterias and other neccessary information were collected under a single link that would be great for not only gsoc students but also for other enthusiastic students :).By provided info we would spend less time to understand the project phases and requirements and more time on

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Joseph Adams
On Fri, Apr 9, 2010 at 4:08 PM, Dimitri Fontaine dfonta...@hi-media.com wrote: I guess a GSoC of reasonable size would be to define a spec for how to implement partitioning in PostgreSQL with a sound and accepted proposal on independent steps to contribute separately, in order to reach the

[HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Necati Batur
Benefits of Project Partitioning refers to splitting what is logically one large table into smaller physical pieces. Partitioning can provide several benefits: Query performance can be improved dramatically in certain situations, particularly when most of the heavily accessed rows of the table

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Robert Haas
On Thu, Apr 8, 2010 at 3:58 PM, Necati Batur necatiba...@gmail.com wrote: *The trigger based operations can be done automatically *The stored procedures can help us to do some functionalities like check constraint problem *manual VACUUM or ANALYZE commands can be handled by using triggers

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Necati Batur
The more specific of the items will just be the exact job I guess. However the detailed form will be hard to write now. Or should I explain the sql issues for each point? 2010/4/8 Necati Batur necatiba...@gmail.com: Benefits of Project Partitioning refers to splitting what is logically one

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Robert Haas
On Thu, Apr 8, 2010 at 4:14 PM, Necati Batur necatiba...@gmail.com wrote: The more specific of the items will just be the exact job I guess. However the detailed form will be hard to write now. Or should I explain the sql issues for each point? Partitioning is a big project. It seems to me

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Necati Batur
In order to make a system change a student need to be more informed and experienced for the issue.Nonetheless,this step of work is actually not the phase of determining all the details,I guess.Otherwise,I would just do a few weeks of coding in summer to complete the project and I would be the

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Robert Haas
On Thu, Apr 8, 2010 at 4:23 PM, Necati Batur necatiba...@gmail.com wrote: In order to make a system change a student need to be more informed and experienced for the issue.Nonetheless,this step of work is actually not the phase of determining all the details,I guess.Otherwise,I would just do a

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Greg Smith
An introduction to the current state of work in progress for adding improved partitioning features to PostgreSQL is documented at http://wiki.postgresql.org/wiki/Table_partitioning If you can find a small, targeted piece of that overall plan that builds on the work already done, and is in the

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Takahiro Itagaki
Greg Smith g...@2ndquadrant.com wrote: An introduction to the current state of work in progress for adding improved partitioning features to PostgreSQL is documented at http://wiki.postgresql.org/wiki/Table_partitioning Also, here is my latest patch for it: