Re: [BUGS] Checkpoints occur too frequently

2004-12-14 Thread Simon Riggs
On Tue, 2004-12-14 at 23:31, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > DEBUG1 messages showed that there is an apparent limit of 255 xlog files > > per checkpoint - > > The volume-based checkpoint trigger code is > > if (IsUnderPostmaster && >

Re: [BUGS] Checkpoints occur too frequently

2004-12-14 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > I'd say no code changes for 8.0, now we know what's causing it. A doc > patch to show the limit is probably just going to annoy the translators > at this stage also. We could adjust guc.c to limit checkpoint_segments to the range 1..255 without having to t

Re: [JDBC] [BUGS] BUG #1347: Bulk Import stopps after a while (

2004-12-14 Thread Oliver Jowett
Kris Jurka wrote: I sent him a driver that was recompiled with MAX_BUFFERED_QUERIES = 1 and he still appears to be having some problems, but I have no idea where. I wonder if he is doing one transaction per batch update loop or something similar. If there's a bottleneck on the server side that's

Re: [JDBC] [BUGS] BUG #1347: Bulk Import stopps after a while (

2004-12-14 Thread Oliver Jowett
Kris Jurka wrote: On Mon, 13 Dec 2004, PostgreSQL Bugs List wrote: The following bug has been logged online: Bug reference: 1347 PostgreSQL version: 8.0 Beta Operating system: Windows XP Description:Bulk Import stopps after a while ( 8.0.0. RC1) - I have written a java program to t

Re: [JDBC] [BUGS] BUG #1347: Bulk Import stopps after a while ( 8.0.0.

2004-12-14 Thread Oliver Jowett
Tom Lane wrote: Kris Jurka <[EMAIL PROTECTED]> writes: // To avoid this, we guess at how many queries we can send before the // server -> driver stream's buffer is full (MAX_BUFFERED_QUERIES). It seems essentially impossible for the driver to do this reliably, since it has no clue how much

Re: [BUGS] Win 32 'could not attach to proper memory at fixed address'

2004-12-14 Thread Bryan Roberts
> > shmget(key=5432001, addr=00DB) failed: Invalid argument > > 2004-12-13 13:01:11 FATAL: could not attach to proper memory > > at fixed address: > > shmget(key=5432001, addr=00DB) failed: Invalid argument > > 2004-12-13 13:01:11 LOG: background writer process (PID > > 3548) exited wit

[BUGS] Checkpoints occur too frequently

2004-12-14 Thread Simon Riggs
Recent OSDL test reports for 8.0RC1 show that checkpoints occur too frequently for higher settings of checkpoint_segments and checkpoint_timeout. This is incorrect according to the manual, and the intention of the current implementation from examining the code. Early tests showed that checkpoints

Re: [BUGS] Checkpoints occur too frequently

2004-12-14 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > DEBUG1 messages showed that there is an apparent limit of 255 xlog files > per checkpoint - The volume-based checkpoint trigger code is if (IsUnderPostmaster && (openLogId != RedoRecPtr.xlogid || op

Re: [BUGS] postgresql-8.0.0 beta5 & postgresql-7.4.6 can't compile

2004-12-14 Thread Luojia Chen
Hi, Please see my inline reply. Bruce Momjian wrote: > Would you tell use what is on this line? > > /usr/include/sys/siginfo.h:259: ctid_t __ctid; /* contract ID */ > Seems you need an extra #include for that platform. Try adding > "#include " before the signal.h inclu

[BUGS] BUG: Installation fails

2004-12-14 Thread Exner, Christian
Hi there, i'd like to test PG8-RC1 (postgresql-8.0.0-rc1.msi) but installation fails. When starting msi file from a cmd i've to select the language (EN, DE, PORT) after this there pops up a small window (maybe something like the msi installation progress) that hides immediately. Installation i