Thread: GSoC's possible project

GSoC's possible project

From
Germán Poó Caamaño
Date:
I'm a student and I'm planning to submit a project for Google Summer of
Code.  I would like to receive feedback about to implement the vacumm
scheduling in order to allow maintenance's windows.

I have read the whole discussion about "Autovacuum improvements"[1]
taken in January.  Alvaro Herrera suggested two improvements,
(probably following an idea of Matthew T. O'Connor), which were:
- Scheduling (a maintenance window)
- Process Handling.

As fas as I know, the process handling is a work in progress[2], while
the scheduling is defined (almost complete) but not implemented yet.

Which is not clear to me (yet), if it would required collecting enough
information through implementing a sort of 'VACUUM SUMMARY'[3].

I would like to receive opinions or suggestions about picking this task.

I haven't explained in more detail what is this scheduling, because I
think, it was clear enough, as far as I understood, in the thread.

Thanks in advance, 

[1] http://archives.postgresql.org/pgsql-hackers/2007-01/msg00684.php
[2] http://archives.postgresql.org/pgsql-hackers/2007-03/msg00639.php
[3] http://archives.postgresql.org/pgsql-hackers/2005-07/msg00409.php

-- 
Germán Poó Caamaño
Concepción - Chile



Re: GSoC's possible project

From
Alvaro Herrera
Date:
Germán Poó Caamaño escribió:
> I'm a student and I'm planning to submit a project for Google Summer of
> Code.  I would like to receive feedback about to implement the vacumm
> scheduling in order to allow maintenance's windows.
> 
> I have read the whole discussion about "Autovacuum improvements"[1]
> taken in January.  Alvaro Herrera suggested two improvements,
> (probably following an idea of Matthew T. O'Connor), which were:
> - Scheduling (a maintenance window)
> - Process Handling.
> 
> As fas as I know, the process handling is a work in progress[2], while
> the scheduling is defined (almost complete) but not implemented yet.

Just for the record, I support this project and I can mentor it.

> Which is not clear to me (yet), if it would required collecting enough
> information through implementing a sort of 'VACUUM SUMMARY'[3].

I would think this is a separate project from the maintenance window
change proper.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


Re: GSoC's possible project

From
Robert Treat
Date:
On Wednesday 21 March 2007 09:07, Alvaro Herrera wrote:
> Germán Poó Caamaño escribió:
> > I'm a student and I'm planning to submit a project for Google Summer of
> > Code.  I would like to receive feedback about to implement the vacumm
> > scheduling in order to allow maintenance's windows.
> >
> > I have read the whole discussion about "Autovacuum improvements"[1]
> > taken in January.  Alvaro Herrera suggested two improvements,
> > (probably following an idea of Matthew T. O'Connor), which were:
> > - Scheduling (a maintenance window)
> > - Process Handling.
> >
> > As fas as I know, the process handling is a work in progress[2], while
> > the scheduling is defined (almost complete) but not implemented yet.
>
> Just for the record, I support this project and I can mentor it.
>
> > Which is not clear to me (yet), if it would required collecting enough
> > information through implementing a sort of 'VACUUM SUMMARY'[3].
>
> I would think this is a separate project from the maintenance window
> change proper.

IF the OP want's the project to be considered, he needs to submit an
application TODAY.  (Read that as I don't see an application in yet)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL