Re: [BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-05 Thread Kris Jurka
On Wed, 5 Dec 2007, Reece Hart wrote: On Wed, 2007-12-05 at 23:20 -0500, Kris Jurka wrote: You need to consider the units. guc.c is in "number of pages", while postgresql.conf is in kB. Since the page size is 8192, these are equivalent. I did consider that, but I'm not certain that it's

Re: [BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-05 Thread Reece Hart
On Wed, 2007-12-05 at 23:20 -0500, Kris Jurka wrote: > You need to consider the units. guc.c is in "number of pages", while > postgresql.conf is in kB. Since the page size is 8192, these are > equivalent. I did consider that, but I'm not certain that it's that simple. Here's why: First, the

Re: [BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-05 Thread Kris Jurka
On Thu, 6 Dec 2007, Reece Hart wrote: Bug reference: 3801 PostgreSQL version: 8.2.5 Description:max_fsm_pages postgresql.conf default != guc.c default Details: The guc.c hardwired default for max_fsm_pages is 2. In postgresql.conf (and .sample), the default is claimed to be 1

Re: [BUGS] BUG #3800: Java/Postgres PreparedStatement returns stale data

2007-12-05 Thread Kris Jurka
On Wed, 5 Dec 2007, Michael Han wrote: The following bug has been logged online: Bug reference: 3800 PostgreSQL version: 8.2 Description:Java/Postgres PreparedStatement returns stale data Details: PROBLEM : Java/Postgres Returns Stale data when underlying Table View is Replaced

[BUGS] BUG #3801: max_fsm_pages postgresql.conf default != guc.c default

2007-12-05 Thread Reece Hart
The following bug has been logged online: Bug reference: 3801 Logged by: Reece Hart Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Linux (SLES 10) Description:max_fsm_pages postgresql.conf default != guc.c default Details: The guc.c har

[BUGS] BUG #3800: Java/Postgres PreparedStatement returns stale data

2007-12-05 Thread Michael Han
The following bug has been logged online: Bug reference: 3800 Logged by: Michael Han Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows Description:Java/Postgres PreparedStatement returns stale data Details: PROBLEM : Java/Postgres R

[BUGS] BUG #3799: csvlog skips some logs

2007-12-05 Thread depesz
The following bug has been logged online: Bug reference: 3799 Logged by: depesz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 HEAD Operating system: linux, 32bit Description:csvlog skips some logs Details: when settings are set to: # select name, setting,