Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Joseph Adams
On Fri, Apr 9, 2010 at 4:08 PM, Dimitri Fontaine 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 > full implementation in

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 Dimitri Fontaine
Alvaro Herrera 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 seems too attra

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

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 devel

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-09 Thread Robert Haas
On Fri, Apr 9, 2010 at 9:10 AM, Necati Batur 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 for improve postg

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 c

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Takahiro Itagaki
Greg Smith 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: http://repo.or.cz/w/pgsql-fdw.git/shortlog/refs/he

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 Robert Haas
On Thu, Apr 8, 2010 at 4:23 PM, Necati Batur 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 few weeks of codi

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 perso

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Robert Haas
On Thu, Apr 8, 2010 at 4:14 PM, Necati Batur 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 that if you want to h

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 : > Benefits of Project > > Partitioning refers to splitting what is logically one large table > into sm

Re: [HACKERS] GSOC PostgreSQL partitioning issue

2010-04-08 Thread Robert Haas
On Thu, Apr 8, 2010 at 3:58 PM, Necati Batur 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 > DBMS SQL can hel

[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 ar