Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-06 Thread Rocco Altier
might explain how that allows it to unfreeze. -rocco > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Magnus Hagander > Sent: Friday, October 06, 2006 6:00 AM > To: Oleg Bartunov > Cc: Pgsql Hackers > Subject: Re: [HA

Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-06 Thread Magnus Hagander
> >> I'm looking into strange locking, which happens on WinXP SP2 SMP > >> machine running 8.1.4 with stats_row_level=on. This is the only > >> combination (# of cpu and stats_row_level) which has problem - > SMP + > >> stats_row_level. > >> > >> The same test runs fine with one cpu (restarted mach

Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-06 Thread Oleg Bartunov
On Thu, 5 Oct 2006, Magnus Hagander wrote: Hi there, I'm looking into strange locking, which happens on WinXP SP2 SMP machine running 8.1.4 with stats_row_level=on. This is the only combination (# of cpu and stats_row_level) which has problem - SMP + stats_row_level. The same test runs fine wi

Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-05 Thread Magnus Hagander
> Hi there, > > I'm looking into strange locking, which happens on WinXP SP2 > SMP machine running 8.1.4 with stats_row_level=on. This is > the only combination (# of cpu and stats_row_level) which has > problem - SMP + stats_row_level. > > The same test runs fine with one cpu (restarted machi

Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-05 Thread Oleg Bartunov
On Thu, 5 Oct 2006, Joshua D. Drake wrote: It's interesting, that there is no problem with 8.2beta1 in all combinations ! Any idea what changes from 8.1.4 to 8.2beta1 could affect the problem ? What do you mean locking? Do you mean the postgresql process locks up? E.g; can you still connect

Re: [HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-05 Thread Joshua D. Drake
> > It's interesting, that there is no problem with 8.2beta1 in all > combinations ! Any idea what changes from 8.1.4 to 8.2beta1 could > affect the problem ? What do you mean locking? Do you mean the postgresql process locks up? E.g; can you still connect to PostgreSQL from another connection?

[HACKERS] Win XP SP2 SMP locking (8.1.4)

2006-10-05 Thread Oleg Bartunov
Hi there, I'm looking into strange locking, which happens on WinXP SP2 SMP machine running 8.1.4 with stats_row_level=on. This is the only combination (# of cpu and stats_row_level) which has problem - SMP + stats_row_level. The same test runs fine with one cpu (restarted machine with /numpro