Re: [BUGS] More graceful handling of invalid log_*_stats conf in 7.4

2005-06-02 Thread Martin Pitt
Hi! Tom Lane [2005-06-02 11:46 -0400]: > Martin Pitt <[EMAIL PROTECTED]> writes: > > I found out that activating > > > log_parser_stats = true > > log_planner_stats = true > > log_executor_stats = true > > log_statement_stats = true > > > in postgresql.conf leads to this bug > > This is another

Re: [BUGS] Postgres 7.4.7 hang in async_notify

2005-06-02 Thread pgsql-bugs
In message <[EMAIL PROTECTED]>, Tom Lane writes: [EMAIL PROTECTED] writes: > We saw the problem with async_notify again (See thread with subject > "Postgres 7.4.6 hang in async_notify" in first message to this list > dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting

Re: [BUGS] Postgres 7.4.7 hang in async_notify

2005-06-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > We saw the problem with async_notify again (See thread with subject > "Postgres 7.4.6 hang in async_notify" in first message to this list > dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting. I've applied a patch that (I think) will fix this. Attached is

Re: [BUGS] Postgres 7.4.7 hang in async_notify

2005-06-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > We saw the problem with async_notify again (See thread with subject > "Postgres 7.4.6 hang in async_notify" in first message to this list > dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting. > Since our last instance, we converted to compiling postgres wit

[BUGS] Postgres 7.4.7 hang in async_notify

2005-06-02 Thread pgsql-bugs
We saw the problem with async_notify again (See thread with subject "Postgres 7.4.6 hang in async_notify" in first message to this list dated "Mon, 25 Apr 2005 15:42:35 -0400") in a production setting. Since our last instance, we converted to compiling postgres with debugging, so we have a stack t

Re: [BUGS] More graceful handling of invalid log_*_stats conf in 7.4

2005-06-02 Thread Tom Lane
Martin Pitt <[EMAIL PROTECTED]> writes: > I found out that activating > log_parser_stats = true > log_planner_stats = true > log_executor_stats = true > log_statement_stats = true > in postgresql.conf leads to this bug This is another manifestation of the 7.4 problem with trying to test superuse

Re: [BUGS] BUG #1697: Select getting slower on continously updating data

2005-06-02 Thread Bruno Wolff III
This does not belong on the pgsql-bugs list. The pgsql-novice or pgsql-performance lists seem more appropiate. I have set followups to the pgsql-novice list. On Thu, Jun 02, 2005 at 12:05:00 +0100, Bahadur Singh <[EMAIL PROTECTED]> wrote: > > Hello, > > I found situtation that, when I am selec

[BUGS] BUG #1697: Select getting slower on continously updating data

2005-06-02 Thread Bahadur Singh
The following bug has been logged online: Bug reference: 1697 Logged by: Bahadur Singh Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 server Description:Select getting slower on continously updating data Details: Hello, I fo

[BUGS] More graceful handling of invalid log_*_stats conf in 7.4

2005-06-02 Thread Martin Pitt
Hi PostgreSQL developers! We just experienced a bug that gave us a serious headache until we found the reason. When doing "psql template1" we got an error message psql: FATAL: invalid cache id: 30 Evert Meulie found a similar problem at http://archives.postgresql.org/pgsql-novice/2004-11/m