Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-23 Thread Merlin Moncure
On 8/18/06, Magnus Hagander <[EMAIL PROTECTED]> wrote: > i doubled all my heap settings and was able to roughly double the - > c > on pgbench from ~158 (stock) to ~330 (modified). so this is > definately the problem. If you try decreasing max_files_per_process to a significantly lower value (s

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-18 Thread Magnus Hagander
> > Maybe this article can help: > > > > Windows and the ClearCase process limit: Understanding the > desktop > > heap > > http://www- > 128.ibm.com/developerworks/rational/library/05/1220_marecha > > l/ > > > > i doubled all my heap settings and was able to roughly double the - > c > on pgbench f

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-18 Thread Magnus Hagander
> Hello, > > I had a customer call in today they are running Win2003 with 22 gig > of ram (that may be a mistype on their end, it may be 32gigs of > ram). > > They cranked up their postgresql max_connections to 500. > > When PostgreSQL hits above 400, it dies and I don't mean a slow > crawl type

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread Joshua D. Drake
Merlin Moncure wrote: what version postgresql? 8.1.4 merlin ---(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] Win32 max connections bug (causing crashes)

2006-08-10 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > On 8/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> So the short answer is "get a real operating system"? > changing a registry setting is not terrible in and of itself, akin to > manually manipluating procfs, but the behavior is in a failure > conditi

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread Merlin Moncure
On 8/10/06, Tom Lane <[EMAIL PROTECTED]> wrote: "William ZHANG" <[EMAIL PROTECTED]> writes: > Maybe this article can help: > Windows and the ClearCase process limit: Understanding the desktop heap > http://www-128.ibm.com/developerworks/rational/library/05/1220_marechal/ So the short answer is "

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread Merlin Moncure
On 8/10/06, William ZHANG <[EMAIL PROTECTED]> wrote: Maybe this article can help: Windows and the ClearCase process limit: Understanding the desktop heap http://www-128.ibm.com/developerworks/rational/library/05/1220_marechal/ i doubled all my heap settings and was able to roughly double the

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread Tom Lane
"William ZHANG" <[EMAIL PROTECTED]> writes: > Maybe this article can help: > Windows and the ClearCase process limit: Understanding the desktop heap > http://www-128.ibm.com/developerworks/rational/library/05/1220_marechal/ So the short answer is "get a real operating system"? I'm not sure I beli

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread William ZHANG
Maybe this article can help: Windows and the ClearCase process limit: Understanding the desktop heap http://www-128.ibm.com/developerworks/rational/library/05/1220_marechal/ ""Merlin Moncure"" [EMAIL PROTECTED] >I confirmed the problem on a fairly recent 8.2devel > > merlin > > On 8/10/06, Merlin

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread Merlin Moncure
I confirmed the problem on a fairly recent 8.2devel merlin On 8/10/06, Merlin Moncure <[EMAIL PROTECTED]> wrote: what version postgresql? merlin ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-10 Thread Merlin Moncure
what version postgresql? merlin ---(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] Win32 max connections bug (causing crashes)

2006-08-09 Thread Joshua D. Drake
Server: Event Type: Information Event Source: PostgreSQL Event Category: None Event ID: 0 Date: 8/9/2006 Time: 8:36:52 PM User: N/A Computer: DAD Description: 2006-08-09 20:36:52 DEBUG: InitPostgres Event Type: Information Event Source:

Re: [HACKERS] Win32 max connections bug (causing crashes)

2006-08-09 Thread Joshua D. Drake
Joshua D. Drake wrote: Hello, I had a customer call in today they are running Win2003 with 22 gig of ram (that may be a mistype on their end, it may be 32gigs of ram). They cranked up their postgresql max_connections to 500. When PostgreSQL hits above 400, it dies and I don't mean a slow cra

[HACKERS] Win32 max connections bug (causing crashes)

2006-08-09 Thread Joshua D. Drake
Hello, I had a customer call in today they are running Win2003 with 22 gig of ram (that may be a mistype on their end, it may be 32gigs of ram). They cranked up their postgresql max_connections to 500. When PostgreSQL hits above 400, it dies and I don't mean a slow crawl type death. A death