Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-21 Thread Bernd Helmle


On Wed, 20 Dec 2006 17:49:15 +0100, Kaare Rasmussen [EMAIL PROTECTED] wrote:
 I'm not sure, but as far as I remember, it will be a short release cycle
 for
 8.3 in order to finish some big items that couldn't be ready in time for
 8.2.

 But which items are more or less expected for 8.3? I recall
 - Hierarchical Queries
 - On disk bitmap index
 - Clustered/replication solutions

 being discussed. What are on people's minds?


I still have updatable views on my radar. I'm currently out of office,
but i'm preparing to put a project page into our wiki tomorrow, so people
could get a slight overview about current implementation and open items.

Bernd

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-21 Thread Lukas Kahwe Smith

Bruce Momjian wrote:


[1] http://developer.postgresql.org/index.php/Todo:WishlistFor83


That looks helpful.


Ok good :)

Seriously though, please slap me when things are wrong, not assigned yet 
to the correct person .. there was a bit of guess work involved with 
some of the points .. especially with the names.


I will let things sit like they are for 1-2 weeks and I will probably 
try to get a hold off each of the people still assigned to items then to 
confirm that they are actually targeting the feature for 8.3 .. or am I 
duplicating Bruce's efforts when I do this?


regards,
Lukas


---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-21 Thread Andrew Dunstan

Lukas Kahwe Smith wrote:

Bruce Momjian wrote:


[1] http://developer.postgresql.org/index.php/Todo:WishlistFor83


That looks helpful.


Ok good :)

Seriously though, please slap me when things are wrong, not assigned 
yet to the correct person .. there was a bit of guess work involved 
with some of the points .. especially with the names.


I will let things sit like they are for 1-2 weeks and I will probably 
try to get a hold off each of the people still assigned to items then 
to confirm that they are actually targeting the feature for 8.3 .. or 
am I duplicating Bruce's efforts when I do this?






To the best of my understanding, the current PSM effort is a pgFoundry 
project to create it as a loadable language. I am not aware of anything 
that would get it to where we could include it in 8.3, so this item 
should probably not be on the list.


Also, clustered/replication solutions seems way too vague. It is not 
clear to me what if anything is in prospect on this front for 8.3.



cheers

andrew

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-21 Thread Bruce Momjian
Lukas Kahwe Smith wrote:
 Bruce Momjian wrote:
 
  [1] http://developer.postgresql.org/index.php/Todo:WishlistFor83
  
  That looks helpful.
 
 Ok good :)
 
 Seriously though, please slap me when things are wrong, not assigned yet 
 to the correct person .. there was a bit of guess work involved with 
 some of the points .. especially with the names.
 
 I will let things sit like they are for 1-2 weeks and I will probably 
 try to get a hold off each of the people still assigned to items then to 
 confirm that they are actually targeting the feature for 8.3 .. or am I 
 duplicating Bruce's efforts when I do this?

What I did for the 8.2 open items tracking during feature freeze was to
list the item description, status, and person's name and email in a
table that could be easily reviewed.  Let me know if you need help
setting that up.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Kaare Rasmussen
I'm not sure, but as far as I remember, it will be a short release cycle for 
8.3 in order to finish some big items that couldn't be ready in time for 8.2. 

But which items are more or less expected for 8.3? I recall
- Hierarchical Queries
- On disk bitmap index
- Clustered/replication solutions

being discussed. What are on people's minds?

-- 

Med venlig hilsen
Kaare Rasmussen, Jasonic

Jasonic Telefon: +45 3816 2582
Nordre Fasanvej 12
2000 Frederiksberg  Email: [EMAIL PROTECTED]

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread David Fetter
On Wed, Dec 20, 2006 at 05:49:15PM +0100, Kaare Rasmussen wrote:
 I'm not sure, but as far as I remember, it will be a short release
 cycle for 8.3 in order to finish some big items that couldn't be
 ready in time for 8.2. 
 
 But which items are more or less expected for 8.3? I recall
 - Hierarchical Queries
 - On disk bitmap index

These two are happening

 - Clustered/replication solutions

This one's stalled because no two replication solutions appear to need
anything in the core.  Instead, lots of things are going on outside
the core in the clustering/replication/HA arena.

 being discussed. What are on people's minds?

Other things coming down the pike are:

* SQL/XML support per SQL:2003
* SQL/PSM support per SQL:2003

Hrm.  While two things isn't much of a pattern, it's suggestive.

Personally, I'd like to see MERGE, windowing functions, and better
integration of (INSERT|UPDATE|DELETE) ... RETURNING.

Cheers,
D (SQL/MED, anybody?)
-- 
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
  Skype: davidfetter

Remember to vote!

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


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Chris Browne
[EMAIL PROTECTED] (Kaare Rasmussen) writes:

 I'm not sure, but as far as I remember, it will be a short release cycle for 
 8.3 in order to finish some big items that couldn't be ready in time for 8.2. 

 But which items are more or less expected for 8.3? I recall
 - Hierarchical Queries
 - On disk bitmap index
 - Clustered/replication solutions

 being discussed. What are on people's minds?

- WITH (recursive) queries
- Better handling of partitioning
- SQL:2003 windowing queries
- Discussion is under way on improvements to autovac
- Simon Riggs has reuse of index tuples under way
-- 
let name=cbbrowne and tld=acm.org in name ^ @ ^ tld;;
http://linuxfinances.info/info/advocacy.html
I think there is a world market for maybe five computers
-- Tom Watson, CEO of IBM, 1943

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Andrew Dunstan

Kaare Rasmussen wrote:
I'm not sure, but as far as I remember, it will be a short release cycle for 
8.3 in order to finish some big items that couldn't be ready in time for 8.2. 


But which items are more or less expected for 8.3? I recall
- Hierarchical Queries
- On disk bitmap index
- Clustered/replication solutions

being discussed. What are on people's minds?

  


Items on my personal agenda for this time frame - all have been 
previously discussed:


. notification payload messages
. fix permissions properly on custom GUC vars
. create a mechanism for plperl to load modules safely

I am committed to getting the first of these done to meet a businees 
need. The last two will be best effort.


cheers

andrew

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


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Lukas Kahwe Smith

Hi,

I just collected all the items mentioned in this thread as well as what 
people quickly came up with on IRC and put it on a list in the developer 
wiki [1]. I tried to put names and links behind the items where ever 
possible. Let me know if there is something missing or if you know any 
other information (links, names) etc. that should be mentioned.


The list is kinda scary long ..

regards
Lukas

[1] http://developer.postgresql.org/index.php/Todo:WishlistFor83

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Bruce Momjian
Lukas Kahwe Smith wrote:
 Hi,
 
 I just collected all the items mentioned in this thread as well as what 
 people quickly came up with on IRC and put it on a list in the developer 
 wiki [1]. I tried to put names and links behind the items where ever 
 possible. Let me know if there is something missing or if you know any 
 other information (links, names) etc. that should be mentioned.
 
 The list is kinda scary long ..
 
 regards
 Lukas
 
 [1] http://developer.postgresql.org/index.php/Todo:WishlistFor83

That looks helpful.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Jonah H. Harris

On 12/20/06, Lukas Kahwe Smith [EMAIL PROTECTED] wrote:

wiki [1]. I tried to put names and links behind the items where ever
possible. Let me know if there is something missing or if you know any
other information (links, names) etc. that should be mentioned.


I know Mark Cave-Ayland was interested in taking over hierarchical
queries... let me see where he stands on it and whether he was going
to complete it on an 8.3 deadline.  If not, I'll do it.

--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation| fax: 732.331.1301
33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED]
Iselin, New Jersey 08830| http://www.enterprisedb.com/

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-20 Thread Bruno Wolff III
On Wed, Dec 20, 2006 at 17:49:15 +0100,
  Kaare Rasmussen [EMAIL PROTECTED] wrote:
 I'm not sure, but as far as I remember, it will be a short release cycle for 
 8.3 in order to finish some big items that couldn't be ready in time for 8.2. 

I believe the point of the short release cycle was more to change the timing
of the release to avoid lots of people being on holiday during a critical
period. After the short release cycle, the tentative plan was to go back to
yearly releases shifted a few months from where they typically used to
occur in the past.
Whether or not this actually works out, remains to be seen.

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


[HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-19 Thread Bruce Momjian
The 8.2.0 release went well.  We spent a month more in beta than we
planned, but that time helped to eliminate many bugs, and many that had
existed in previous PostgreSQL major releases as well.  We have had very
few bug reports for 8.2.0, and will be doing a minor release in 1-2
weeks to get those fixes out to the user community.

The development community is now focused on 8.3, and discussion and
patch application has already started.  This is scheduled to be a
shorter release cycle then normal, with feature freeze on April 1, with
major functionality discussed and hopefully reviewed by the community at
least a month before that.  This would put beta in mid-May, and final
release perhaps mid-July.  Of course, this all might change based on
community feedback.

-- 
  Bruce Momjian   [EMAIL PROTECTED]
  EnterpriseDBhttp://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match


Re: [HACKERS] Release 8.2.0 done, 8.3 development starts

2006-12-19 Thread Thomas H.

The 8.2.0 release went well.  We spent a month more in beta than we
planned, but that time helped to eliminate many bugs, and many that had
existed in previous PostgreSQL major releases as well.  We have had very
few bug reports for 8.2.0, and will be doing a minor release in 1-2
weeks to get those fixes out to the user community.


any chance of having the win32 relation file permission bug looked at again 
for the minor release? this still worries us quite a bit here...


best regards,
thomas 




---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq