Re: [HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Marc G. Fournier
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 - --On Tuesday, February 05, 2008 10:00:29 +0100 Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Mon, Feb 04, 2008 at 08:36:47PM -0500, Tom Lane wrote: >> Andrew Dunstan <[EMAIL PROTECTED]> writes: >> > I don't really buy the double patching argume

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Tom Lane
I wrote: > The answer is "no, it doesn't work": > $ psql -l > psql: GSSAPI continuation error: Invalid token was supplied > GSSAPI continuation error: No error > $ > This surprises me; I would have thought the protocol was fairly > orthogonal to the auth method. We should look into it and see >

Re: [HACKERS] configurability of OOM killer

2008-02-05 Thread Decibel!
On Tue, Feb 05, 2008 at 01:54:17PM -0800, Ron Mayer wrote: > Decibel! wrote: > > > > Yes, this problem goes way beyond OOM. Just try and configure > > work_memory aggressively on a server that might see 50 database > > connections, and do it in such a way that you won't swap. Good luck. > > That

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > On Tue, Jan 29, 2008 at 03:34:19AM -0500, Kris Jurka wrote: >> Is it possible to authenticate using GSSAPI over the V2 protocol? Is >> there any documentation on the message formats for V2? > Honestly - don't know :-) Never looked at that part. I tr

[HACKERS] Where is share\locale dir on Win?

2008-02-05 Thread Gevik Babakhani
Is it my imagination or the share\locale directory for nls support just does not get installed on Windows. (Even with NLS option chosen). It does for 8.2 Regards, Gevik. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Feature Freeze Date for Next Release

2008-02-05 Thread Tom Lane
Ron Mayer <[EMAIL PROTECTED]> writes: > Simon Riggs wrote: >> Can I ask when the Feature Freeze for next release will be? > Also, from http://www.postgresql.org/about/press/faq > "Q: When will 8.4 come out? >A: Historically, PostgreSQL has released approximately > every 12 months and

Re: [HACKERS] Feature Freeze Date for Next Release

2008-02-05 Thread Joshua D. Drake
On Tue, 05 Feb 2008 13:56:48 -0800 Ron Mayer <[EMAIL PROTECTED]> wrote: > Simon Riggs wrote: > > Can I ask when the Feature Freeze for next release will be? > > Also, from http://www.postgresql.org/about/press/faq > > "Q: When will 8.4 come out? >A: Historically, PostgreSQL has released a

Re: [HACKERS] Feature Freeze Date for Next Release

2008-02-05 Thread Ron Mayer
Simon Riggs wrote: > Can I ask when the Feature Freeze for next release will be? Also, from http://www.postgresql.org/about/press/faq "Q: When will 8.4 come out? A: Historically, PostgreSQL has released approximately every 12 months and there is no desire in the community to cha

Re: [HACKERS] configurability of OOM killer

2008-02-05 Thread Ron Mayer
Decibel! wrote: > > Yes, this problem goes way beyond OOM. Just try and configure > work_memory aggressively on a server that might see 50 database > connections, and do it in such a way that you won't swap. Good luck. That sounds like an even broader and more difficult problem than managing memo

Re: [HACKERS] [BUGS] BUG #3909: src\tools\msvc\clean.bat clears parse.h file

2008-02-05 Thread Dave Page
On Feb 5, 2008 5:56 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > Dave Page wrote: > > On Feb 5, 2008 3:24 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > >> On Mon, Jan 28, 2008 at 06:27:05PM +, Pavel Golub wrote: > >> I think a better solution is to add a parameter to clean.bat to make

Re: [HACKERS] configurability of OOM killer

2008-02-05 Thread Decibel!
On Mon, Feb 04, 2008 at 08:46:26PM +, Simon Riggs wrote: > On Mon, 2008-02-04 at 15:31 -0500, Tom Lane wrote: > > > I cannot see any way of restricting global memory > > consumption that won't hurt performance and flexibility. > > We've discussed particular ways of doing this previously and n

Re: [HACKERS] Feature Freeze Date for Next Release

2008-02-05 Thread Ron Mayer
Wouldn't seeing which patches are trickling in during the first months of 8.4 development give a better indication of when it should be freezable? I'm all in favor of having lots of advance notice and predictable schedules --- but it seems in the next month or so we'll have a lot more insight of

Re: [HACKERS] Feature Freeze Date for Next Release

2008-02-05 Thread Dave Page
On Feb 5, 2008 8:57 PM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > Can I ask when the Feature Freeze for next release will be? I shall be posting on this topic in the next day or so. /D ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Feature Freeze Date for Next Release

2008-02-05 Thread Simon Riggs
Can I ask when the Feature Freeze for next release will be? Last time we discussed this the only date mentioned was end-March-2008, which is less than 2 months away now. We've long expressed the wish to move development onto a cycle that ends in the Spring, so next alternative would appear to be

Re: [HACKERS] Possible BUG in MSVC Install.pm in GenerateNLSFiles

2008-02-05 Thread Gevik Babakhani
> The traces from buildfarm baiji seem to indicate that at > least some NLS files are installed. > Those three dots are printed as default. (looking at Install.pm:456) Regards, Gevik. ---(end of broadcast)--- TIP 3: Have you checked our extens

Re: [HACKERS] Possible BUG in MSVC Install.pm in GenerateNLSFiles

2008-02-05 Thread Andrew Dunstan
Gevik Babakhani wrote: Hi, Is it only on my system or the Install.pm:GenerateNLSFiles just does not copy any NLS files. It seems that in Install.pm:468:next.po$/); does not let anything through. Can someone please confirm? The traces from buildfarm baiji seem to indicate that at l

Re: [HACKERS] Remove pg_dump -i option (was Re: Proposed patch: synchronized_scanning GUC variable)

2008-02-05 Thread Dave Page
On Feb 5, 2008 6:11 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > Please go ahead and remove the -i - it's not like users cannot cannot > > specify which set of pg utilities to use if they need a specific > > version. > > Ok, done! Thanks. /D ---(end of broadcast)--

[HACKERS] Possible BUG in MSVC Install.pm in GenerateNLSFiles

2008-02-05 Thread Gevik Babakhani
Hi, Is it only on my system or the Install.pm:GenerateNLSFiles just does not copy any NLS files. It seems that in Install.pm:468:next.po$/); does not let anything through. Can someone please confirm? Regards, Gevik. ---(end of broadcast)--- T

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Magnus Hagander
Kris Jurka wrote: On Tue, 5 Feb 2008, Magnus Hagander wrote: Does this mean you have GSSAPI auth working for protocol v3? :-) Yes, but since I'm not terribly familiar with GSSAPI or JAAS, I'm not sure what configuration options need to get exposed to the user. http://archives.postgresql

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Kris Jurka
On Tue, 5 Feb 2008, Magnus Hagander wrote: Does this mean you have GSSAPI auth working for protocol v3? :-) Yes, but since I'm not terribly familiar with GSSAPI or JAAS, I'm not sure what configuration options need to get exposed to the user. http://archives.postgresql.org/pgsql-jdbc/200

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Magnus Hagander
Kris Jurka wrote: On Tue, 5 Feb 2008, Magnus Hagander wrote: On Tue, Jan 29, 2008 at 03:34:19AM -0500, Kris Jurka wrote: Is it possible to authenticate using GSSAPI over the V2 protocol? Is there any documentation on the message formats for V2? Honestly - don't know :-) Never looked at t

Re: [HACKERS] Remove pg_dump -i option (was Re: Proposed patch: synchronized_scanning GUC variable)

2008-02-05 Thread Magnus Hagander
Dave Page wrote: On Feb 5, 2008 3:27 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: On Thu, Jan 31, 2008 at 11:02:03AM -0500, Bruce Momjian wrote: Tom Lane wrote: I would be satisfied with that if I thought people would actually read the message. My complaint is really directed at certain adm

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Kris Jurka
On Tue, 5 Feb 2008, Magnus Hagander wrote: On Tue, Jan 29, 2008 at 03:34:19AM -0500, Kris Jurka wrote: Is it possible to authenticate using GSSAPI over the V2 protocol? Is there any documentation on the message formats for V2? Honestly - don't know :-) Never looked at that part. I mean, t

Re: [HACKERS] [BUGS] BUG #3909: src\tools\msvc\clean.bat clears parse.h file

2008-02-05 Thread Magnus Hagander
Dave Page wrote: On Feb 5, 2008 3:24 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: On Mon, Jan 28, 2008 at 06:27:05PM +, Pavel Golub wrote: I think a better solution is to add a parameter to clean.bat to make it work like "make clean" does. So you'd to "clean" when you mean "make clean", an

Re: [HACKERS] Why are we waiting?

2008-02-05 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Mon, 2008-02-04 at 17:06 -0500, Tom Lane wrote: >> Basically I'd rather try to attack the problem with dtrace ... > OK. I'll switch to Solaris. Or do you something I don't about dtrace on > linux? Nope :-(. The SystemTap guys keep promising support fo

Re: [HACKERS] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-02-05 Thread Gregory Stark
"Gregory Stark" <[EMAIL PROTECTED]> writes: > So I had a thought about how to soften the controversial hard cutoff of 100 > for the use of the histogram selectivity. Instead of switching 100% one way or > the other between the two heuristics why not calculate both and combine them. > The larger th

Re: [HACKERS] [BUGS] BUG #3909: src\tools\msvc\clean.bat clears parse.h file

2008-02-05 Thread Dave Page
On Feb 5, 2008 3:24 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Mon, Jan 28, 2008 at 06:27:05PM +, Pavel Golub wrote: > > > I think a better solution is to add a parameter to clean.bat to make it > work like "make clean" does. So you'd to "clean" when you mean "make > clean", and "clean

Re: [HACKERS] Remove pg_dump -i option (was Re: Proposed patch: synchronized_scanning GUC variable)

2008-02-05 Thread Dave Page
On Feb 5, 2008 3:27 PM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > On Thu, Jan 31, 2008 at 11:02:03AM -0500, Bruce Momjian wrote: > > Tom Lane wrote: > > > I would be satisfied with that if I thought people would actually read > > > the message. My complaint is really directed at certain admin p

Re: [HACKERS] Problem with site doc search

2008-02-05 Thread Magnus Hagander
No. It's on the list, but other things around the release haev priority. //Magnus On Mon, Feb 04, 2008 at 06:43:09PM -0800, Gurjeet Singh wrote: > Hi guys any updates on this? Pinging you just so that we do not forget > it in the heap of mails in our inboxes. > > Best regards, > > On Feb 3,

Re: [HACKERS] Remove pg_dump -i option (was Re: Proposed patch: synchronized_scanning GUC variable)

2008-02-05 Thread Magnus Hagander
On Thu, Jan 31, 2008 at 11:02:03AM -0500, Bruce Momjian wrote: > Tom Lane wrote: > > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > > Am Donnerstag, 31. Januar 2008 schrieb Alvaro Herrera: > > >> Effect: we would stop receiving complaints that an old pg_dump can talk > > >> to a server that most

Re: [HACKERS] GSSAPI and V2 protocol

2008-02-05 Thread Magnus Hagander
On Tue, Jan 29, 2008 at 03:34:19AM -0500, Kris Jurka wrote: > > Is it possible to authenticate using GSSAPI over the V2 protocol? Is > there any documentation on the message formats for V2? Honestly - don't know :-) Never looked at that part. I mean, the V2 protocol is *really* old by now, isn'

Re: [HACKERS] [BUGS] BUG #3909: src\tools\msvc\clean.bat clears parse.h file

2008-02-05 Thread Magnus Hagander
On Mon, Jan 28, 2008 at 06:27:05PM +, Pavel Golub wrote: > > The following bug has been logged online: > > Bug reference: 3909 > Logged by: Pavel Golub > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3RC2 > Operating system: WinXP > Description:src\tool

Re: [HACKERS] Why are we waiting?

2008-02-05 Thread Simon Riggs
On Tue, 2008-02-05 at 14:14 +, Heikki Linnakangas wrote: > Simon Riggs wrote: > > On Mon, 2008-02-04 at 17:06 -0500, Tom Lane wrote: > > > >> Basically I'd rather try to attack the problem with dtrace ... > > > > OK. I'll switch to Solaris. Or do you something I don't about dtrace on > > linu

[HACKERS] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-02-05 Thread Gregory Stark
So I had a thought about how to soften the controversial hard cutoff of 100 for the use of the histogram selectivity. Instead of switching 100% one way or the other between the two heuristics why not calculate both and combine them. The larger the sample size from the histogram the more we can wei

Re: [HACKERS] path with spaces in config.pl

2008-02-05 Thread Magnus Hagander
On Tue, Feb 05, 2008 at 01:55:40PM +0100, Gevik Babakhani wrote: > > Or we should fix it, if we can figure out why. Is it the fact > > that it only works with what happens to be the directory > > layout I use, or is it the space in the filename that's > > breaking something? Can you test a third

Re: [HACKERS] Why are we waiting?

2008-02-05 Thread Heikki Linnakangas
Simon Riggs wrote: On Mon, 2008-02-04 at 17:06 -0500, Tom Lane wrote: Basically I'd rather try to attack the problem with dtrace ... OK. I'll switch to Solaris. Or do you something I don't about dtrace on linux? One idea would be to add new arguments to LWLockAcquire as you suggest, but in

Re: [HACKERS] [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Gregory Stark
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > Gregory Stark wrote: >> "Andrew Dunstan" <[EMAIL PROTECTED]> writes: >> >>> Tom Lane wrote: >>> >>> With the branch delayed they will have to say "Oh, there's a new >>> release. I wonder when they will branch so I can start building the new >>> branc

Re: [HACKERS] path with spaces in config.pl

2008-02-05 Thread Gevik Babakhani
> Or we should fix it, if we can figure out why. Is it the fact > that it only works with what happens to be the directory > layout I use, or is it the space in the filename that's > breaking something? Can you test a third case to figure that out? > I think it is the darn msbuild which accept

[HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Andrew Dunstan
Gregory Stark wrote: "Andrew Dunstan" <[EMAIL PROTECTED]> writes: Tom Lane wrote: With the branch delayed they will have to say "Oh, there's a new release. I wonder when they will branch so I can start building the new branch." No, I wrote that, not Tom. Your snipping went s

Re: [HACKERS] [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Gregory Stark
"Andrew Dunstan" <[EMAIL PROTECTED]> writes: > Tom Lane wrote: > > With the branch delayed they will have to say "Oh, there's a new > release. I wonder when they will branch so I can start building the new > branch." Doesn't that just mean they should be sure to announce the branch loudly when i

Re: [HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Dave Page
On Feb 5, 2008 11:50 AM, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > This probably wasn't on the core team's horizon - IIRC Dave is the only > member of core who runs a buildfarm member. To be honest the zoo beside me didn't even cross my mind when that thread happened. I didn't pay much attenti

Re: [HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: I don't really buy the double patching argument. Back patching becomes more difficult when there has been significant code drit, but we surely don't expect that much drift in the next week or two. Back patching when there has been

Re: [HACKERS] path with spaces in config.pl

2008-02-05 Thread Magnus Hagander
On Tue, Feb 05, 2008 at 11:11:42AM +0100, Gevik Babakhani wrote: > Hi, > > I would like report an observations regarding compilation with msvc++ > I was trying to compile with nls=>'C:\Program Files\GnuWin32\' (of course > with GetText installed and everything) > The build process breaks on link w

Re: [HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Magnus Hagander
On Tue, Feb 05, 2008 at 10:57:16AM +, Dave Page wrote: > On Feb 5, 2008 9:00 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > > > I assume this vote was taken out on -core? I don't mind -core deciding on > > this, not at all, but I would appreciate it if you would post the result of > > the vo

Re: [HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Dave Page
On Feb 5, 2008 9:00 AM, Magnus Hagander <[EMAIL PROTECTED]> wrote: > I assume this vote was taken out on -core? I don't mind -core deciding on > this, not at all, but I would appreciate it if you would post the result of > the vote on -hackers. It wasn't a 'vote' in the formal sense. It was just

Re: [HACKERS] Re: [COMMITTERS] pgsql: configure tag'd 8.3.0 and built witih autoconf 2.59

2008-02-05 Thread Magnus Hagander
On Mon, Feb 04, 2008 at 08:36:47PM -0500, Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > > I don't really buy the double patching argument. Back patching becomes > > more difficult when there has been significant code drit, but we surely > > don't expect that much drift in the nex

[HACKERS] path with spaces in config.pl

2008-02-05 Thread Gevik Babakhani
Hi, I would like report an observations regarding compilation with msvc++ I was trying to compile with nls=>'C:\Program Files\GnuWin32\' (of course with GetText installed and everything) The build process breaks on link with missing "Program.obj" error. When I changed nls='C:\prog\pgsql\depend\get

Re: [HACKERS] Page-at-a-time Locking Considerations

2008-02-05 Thread Simon Riggs
On Mon, 2008-02-04 at 18:08 -0300, Alvaro Herrera wrote: > Simon Riggs wrote: > > On Mon, 2008-02-04 at 20:03 +, Gregory Stark wrote: > > > > > I wonder how hard it would be to shove the clog into regular shared > > > memory pages and let the clock sweep take care of adjusting the > > > percen

Re: [HACKERS] Why are we waiting?

2008-02-05 Thread Simon Riggs
On Mon, 2008-02-04 at 17:06 -0500, Tom Lane wrote: > Basically I'd rather try to attack the problem with dtrace ... OK. I'll switch to Solaris. Or do you something I don't about dtrace on linux? -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---(end of bro

Re: [HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-05 Thread Gevik Babakhani
(I really should stop reading the code after 12:00AM) So if I understand correctly, the proper solution would be to handle the localized (TM) format within to_date (seq_search). This means that prior calling to_date a SET LC_MESSAGES must be given. but if we are following Oracle, (http://www.techo

Re: [HACKERS] TODO item:Allow to_date() and to_timestamp() accept localized month names

2008-02-05 Thread Peter Eisentraut
Alvaro Herrera wrote: > Nevertheless, I think there's something interesting missing here, which > is a sort of strftime's %c format string. I think the Oracle way to do that would be to_char() with one argument and setting NLS_DATE_FORMAT. -- Peter Eisentraut http://developer.postgresql.org/~pe