Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Development Plans

From: Simone Brunozzi <simone(dot)brunozzi(at)wedoit(dot)us>
To: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] Development Plans
Date: 2005-02-28 10:34:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-advocacypgsql-hackers
I'd like to add my personal opinion on development plans,
not regarding the pure coding, but the contour instead.
(I'm not a real PG expert, so I'm limited to this).

As a university teacher, I feel the lack of introductory and explanatory 
material for postgresql.
I think it would be really good if somebody really expert can prepare 
videos and slides and share it on the web site. Possibly in english, but 
with some sort of subtitles in the case of videos.

This is not just to cover the normal topics of Postgresql, but instead 
also something regarding migration issues, development plannings, etc...
I mean, some sort of documentation that is not just barely how to use 
it, but something derived from the direct experience in real world 

I don't know if these considerations fit in the subject of this thread, 
but I think that having a development path can be very valuable if that 
path is shared and simply explained to "nobrainers" or normal students 
and users.



Neil Conway wrote:
> Tom Lane wrote:
>> I wouldn't mind seeing people be a little more vocal on the hackers list
>> about what they plan to be doing, just so that there's not duplication
>> of effort.
> Stuff I have done in some form that I need to finish up and submit:
> - GiST improvements: sane memory management, 10% scan perf. improvement 
> (not sure if I'll get to WAL and page-level locking for 8.1)
> - CREATE TABLE AS overhaul & SQL 2003 compliance
> - pl/pgsql dead code checking (only for trivially-dead code)
> - default_with_oids=true by default
> - use # of CPUs at runtime to adjust spinlock behavior for UP systems
> Interested in looking at for 8.1 but no code yet:
> - PREPARE planning improvements (at the least, do the planning when we 
> see the first EXECUTE, as in the fe/be protocol-level prepared statements)
> - various planner improvements; haven't really decided what specifically 
> to do, yet
> - logical column ordering, and possibly repacking of physical order of 
> columns to optimize disk space consumption by reducing alignment/padding 
> requirements
> - O_DIRECT for WAL
> - UNIQUE predicate per SQL2003
> Investigated, probably not worth pursuing:
> - GCC PGO support. At least in GCC 3.4, PGO is sufficiently flaky it 
> isn't really worth adding support for it. Maybe I'll take another look 
> when GCC 4.0 is out.
> - futexes in PG spinlocks. Didn't solve the CS problem, perf. 
> improvement possibly (?) not worth the portability headaches.
> (Of course, absolutely no guarantees that I actually get around to 
> implementing any of this stuff, this is just what's on my mind at the 
> moment...)
> -Neil
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?


Ing. iunior Simone Brunozzi

WEDOIT s.a.s. - Soluzioni informatiche

Via protomartiri Francescani, 26
06088 Assisi (PG) - ITALY

Tel. +39 075-8041195
Cell. +39 340-5768488

In response to

pgsql-hackers by date

Next:From: Nicolai TufarDate: 2005-02-28 13:27:14
Subject: Re: snprintf causes regression tests to fail
Previous:From: Richard HuxtonDate: 2005-02-28 09:46:24
Subject: Re: serial as FK ?

pgsql-advocacy by date

Next:From: Robert BernierDate: 2005-02-28 15:10:44
Subject: Re: call me when you finally get the CDs
Previous:From: Neil ConwayDate: 2005-02-28 00:22:26
Subject: Re: [HACKERS] Development Plans

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group