Re: [HACKERS] Getting to beta1

2010-03-19 Thread Simon Riggs
On Sat, 2010-03-13 at 16:58 +, Simon Riggs wrote: On Fri, 2010-03-12 at 22:28 -0500, Bruce Momjian wrote: Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I don't see many

Re: [HACKERS] Getting to beta1

2010-03-19 Thread Csaba Nagy
Hi all, On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: Or, let's put it another way: I've made my opinion clear in the past that I think that we ought to ship with a minimal postgresql.conf with maybe 15 items in it. If we are going to continue to ship with postgresql.conf kitchen

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Simon Riggs
On Wed, 2010-03-17 at 23:29 -0400, Bruce Momjian wrote: Simon Riggs wrote: On Sat, 2010-03-13 at 11:26 -0800, Josh Berkus wrote: The list has been reduced greatly in the past week. What about HS/SR open items? I'd like to see vacuum_defer_cleanup_age added to the Archive section

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Josh Berkus
It's already in the docs, so if they read it and understand it they can add it to the postgresql.conf if they so choose. I agree with Josh Berkus that vacuum_defer_cleanup_age should be in postgresql.conf. We don't stop listing items just because they are dangerous, e.g. fsync, or to

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Joshua D. Drake
On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: It's already in the docs, so if they read it and understand it they can add it to the postgresql.conf if they so choose. I agree with Josh Berkus that vacuum_defer_cleanup_age should be in postgresql.conf. We don't stop listing

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Greg Smith
Joshua D. Drake wrote: As usual, the postgresql.conf is entirely too full. We should ship with the top 15. Maybe, but what we should do is ship, and then talk about this again when it's appropriate--earlier in the release cycle. Let me try and cut this one off before it generates a bunch of

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Marc G. Fournier
On Thu, 18 Mar 2010, Joshua D. Drake wrote: On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: It's already in the docs, so if they read it and understand it they can add it to the postgresql.conf if they so choose. I agree with Josh Berkus that vacuum_defer_cleanup_age should be in

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Robert Haas
On Thu, Mar 18, 2010 at 4:28 PM, Marc G. Fournier scra...@hub.org wrote: On Thu, 18 Mar 2010, Joshua D. Drake wrote: On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: It's already in the docs, so if they read it and understand it they can add it to the postgresql.conf if they so choose.

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Joshua D. Drake
On Thu, 2010-03-18 at 19:10 -0400, Robert Haas wrote: On Thu, Mar 18, 2010 at 4:28 PM, Marc G. Fournier scra...@hub.org wrote: On Thu, 18 Mar 2010, Joshua D. Drake wrote: On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: It's already in the docs, so if they read it and understand it

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Greg Smith
Robert Haas wrote: On Thu, Mar 18, 2010 at 4:28 PM, Marc G. Fournier scra...@hub.org wrote: On Thu, 18 Mar 2010, Joshua D. Drake wrote: On Thu, 2010-03-18 at 10:18 -0700, Josh Berkus wrote: Or, let's put it another way: I've made my opinion clear in the past that I think that

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Josh Berkus
On 3/18/10 4:54 PM, Greg Smith wrote: If this is turning into a vote: -1 from me for any work on this until http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items is cleared. It boggles my mind that anyone could have a different prioritization right now. Yes. I wasn't suggesting that

Re: [HACKERS] Getting to beta1

2010-03-18 Thread Robert Haas
On Thu, Mar 18, 2010 at 7:54 PM, Greg Smith g...@2ndquadrant.com wrote: If this is turning into a vote:  -1 from me for any work on this until http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items is cleared.  It boggles my mind that anyone could have a different prioritization right now.

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Josh Berkus
All, A user at SFPUG last night pointed out why we should release a beta, rather than an alpha, sooner rather than later: because there are no Windows packages for Alphas. Currently, our Windows users are *not* testing 9.0. Which means we're just putting off the day when we hear about

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Dave Page
On Wed, Mar 17, 2010 at 4:54 PM, Josh Berkus j...@agliodbs.com wrote: All, A user at SFPUG last night pointed out why we should release a beta, rather than an alpha,  sooner rather than later: because there are no Windows packages for Alphas. Yes there:

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Josh Berkus
Yes there: http://www.enterprisedb.com/products/pgdevdownload.do We've produced them since Alpha 2 iirc. Oh! Most people don't know about these ... I need to advertise them! BTW, at SFPUG there were reports of some kind of issue with the One-Click installer for 8.4.3. Is that resolved, or

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Dave Page
On Wed, Mar 17, 2010 at 5:02 PM, Josh Berkus j...@agliodbs.com wrote: Yes there: http://www.enterprisedb.com/products/pgdevdownload.do We've produced them since Alpha 2 iirc. Oh!  Most people don't know about these ... I need to advertise them! They're linked from here, which you may want

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Josh Berkus
Not aware of any issues - certainly none cropped up in QA. In fact, this release should fix one of the long standing initdb failures we see occasionally on some secure environments. OK, I'll ask on our mailing list. -- -- Josh Berkus

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Simon Riggs
On Sat, 2010-03-13 at 11:26 -0800, Josh Berkus wrote: The list has been reduced greatly in the past week. What about HS/SR open items? I'd like to see vacuum_defer_cleanup_age added to the Archive section of postgresql.conf, Not all parameters are in postgresql.conf.sample. Encouraging

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Simon Riggs
On Mon, 2010-03-15 at 18:20 +0900, Fujii Masao wrote: On Sat, Mar 13, 2010 at 12:28 PM, Bruce Momjian br...@momjian.us wrote: Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Bruce Momjian
Simon Riggs wrote: On Sat, 2010-03-13 at 11:26 -0800, Josh Berkus wrote: The list has been reduced greatly in the past week. What about HS/SR open items? I'd like to see vacuum_defer_cleanup_age added to the Archive section of postgresql.conf, Not all parameters are in

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Bruce Momjian
Bruce Momjian wrote: Simon Riggs wrote: On Sat, 2010-03-13 at 11:26 -0800, Josh Berkus wrote: The list has been reduced greatly in the past week. What about HS/SR open items? I'd like to see vacuum_defer_cleanup_age added to the Archive section of postgresql.conf, Not

Re: [HACKERS] Getting to beta1

2010-03-17 Thread Robert Haas
On Wed, Mar 17, 2010 at 11:42 PM, Bruce Momjian br...@momjian.us wrote: Bruce Momjian wrote: Simon Riggs wrote: On Sat, 2010-03-13 at 11:26 -0800, Josh Berkus wrote: The list has been reduced greatly in the past week.  What about HS/SR open items? I'd like to see

Re: [HACKERS] Getting to beta1

2010-03-16 Thread Dimitri Fontaine
Josh Berkus j...@agliodbs.com writes: Yes, and on pgsql-docs rather than on this mailing list. Or ... J.F.D.I (Just F Do It). That is, if someone contributed a whole buncha new text to the tutorial on pgsql-docs, I can't imagine it being rejected out of hand. That was the bulk of the

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Fujii Masao
On Sat, Mar 13, 2010 at 12:28 PM, Bruce Momjian br...@momjian.us wrote: Where are we in getting to beta1?  I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues?  I don't see many on the main 9.0 open items page:        

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Dimitri Fontaine
David E. Wheeler da...@kineticode.com writes: On Mar 14, 2010, at 3:38 PM, Josh Berkus wrote: I'm planning on writing a Guide to HS SR for the beta. Originally I planned to put this in the main docs, but I couldn't figure out how to fit it in there structurally. Plus, it needs more

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Greg Smith
Dimitri Fontaine wrote: Maybe some more admin level tutorial would be great to have too, such as how to find what's locking, how to monitor table and index usage to determine which indexes to drop, which to create, how to monitor things (slaves lag, hitratio, transactions, I/U/D activity, you

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Dimitri Fontaine
Greg Smith g...@2ndquadrant.com writes: Dimitri Fontaine wrote: Maybe some more admin level tutorial would be great to have too, such as how to find what's locking, how to monitor table and index usage to determine which indexes to drop, which to create, how to monitor things (slaves lag,

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Tom Lane
Dimitri Fontaine dfonta...@hi-media.com writes: A lot of things are described in the manual and provided in munin or nagios plugins already, but still the Tutorial looks like a good place to give the recipes, ready-to-go queries etc. This sounds like a pretty horrid idea. The tutorial is

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Dimitri Fontaine
Tom Lane t...@sss.pgh.pa.us writes: This sounds like a pretty horrid idea. The tutorial is meant to be read first, so it cannot depend on having already read any of the main documentation. If we try to fill it with hints and tricks then either it will be completely unintelligible to newbies,

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Josh Berkus
On 3/15/10 5:47 AM, Dimitri Fontaine wrote: Maybe it's time to start another thread if people want to follow-up on expanding our tutorial. Yes, and on pgsql-docs rather than on this mailing list. Or ... J.F.D.I (Just F Do It). That is, if someone contributed a whole buncha new text to the

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Bruce Momjian
Josh Berkus wrote: Devs, Also, I would like to have a Beta or at least a new alpha release before April 3 for the test-fest, so that our volunteers aren't testing bugs which are already patched. We can easily create another alpha by April 3. I think the big question is whether we can put

Re: [HACKERS] Getting to beta1

2010-03-15 Thread Robert Haas
On Mon, Mar 15, 2010 at 4:24 PM, Bruce Momjian br...@momjian.us wrote: We can easily create another alpha by April 3.  I think the big question is whether we can put out beta1 while we still have open HS/SR issues. My guess is no.  My other guess is that we will still have open HS/SR issues on

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Heikki Linnakangas
Simon Riggs wrote: I have these things on my list * Minor page xid bug fix * btree delete standby-side derivation of xid * review of StartupXLog issue, on open items list, has an effect on HS I expect to be finished with those by Wed, perhaps Thurs. Don't forget the start from shutdown

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Simon Riggs
On Sun, 2010-03-14 at 16:53 +0200, Heikki Linnakangas wrote: Simon Riggs wrote: I have these things on my list * Minor page xid bug fix * btree delete standby-side derivation of xid * review of StartupXLog issue, on open items list, has an effect on HS I expect to be finished with

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Josh Berkus
On 3/14/10 9:02 AM, Simon Riggs wrote: An explanation in the docs would be good. And also a hint of how to failover if you decide in an emergency that the absence was a mistake, in retrospect. I'm planning on writing a Guide to HS SR for the beta. Originally I planned to put this in the main

Re: [HACKERS] Getting to beta1

2010-03-14 Thread Josh Berkus
Devs, Also, I would like to have a Beta or at least a new alpha release before April 3 for the test-fest, so that our volunteers aren't testing bugs which are already patched. --Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Getting to beta1

2010-03-14 Thread David E. Wheeler
On Mar 14, 2010, at 3:38 PM, Josh Berkus wrote: I'm planning on writing a Guide to HS SR for the beta. Originally I planned to put this in the main docs, but I couldn't figure out how to fit it in there structurally. Plus, it needs more examples, output samples, and a tutorial feel.

Re: [HACKERS] Getting to beta1

2010-03-13 Thread Simon Riggs
On Fri, 2010-03-12 at 22:28 -0500, Bruce Momjian wrote: Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I don't see many on the main 9.0 open items page:

Re: [HACKERS] Getting to beta1

2010-03-13 Thread Josh Berkus
The list has been reduced greatly in the past week. What about HS/SR open items? I'd like to see vacuum_defer_cleanup_age added to the Archive section of postgresql.conf, and add it to the docs (I'll write something this week). I'd like to get rid of the associated hint-bits bogus error

[HACKERS] Getting to beta1

2010-03-12 Thread Bruce Momjian
Where are we in getting to beta1? I know people are looking to me for 9.0 release notes and I will have them done in about a week, but what about open issues? I don't see many on the main 9.0 open items page: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items#Bugs The list has