Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 18:44, Scott Marlowe wrote: > On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang wrote: > > Weird that I receive your each message twice. > > On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura < > rsmog...@softperience.eu> > > wrote: > >> > >> Simple and obvious question right now do

Re: [GENERAL] Weird problem that enormous locks

t;>> >>>> >>>> >>>>> Regards, >>>>> Radoslaw Smogura >>>>> (mobile) >>>>> - >>>>> From: Tony Wang >>>>> Sent: 15 lipca 2011 03:51 >

Re: [GENERAL] Weird problem that enormous locks

On Friday, July 15, 2011 3:52:13 am Radosław Smogura wrote: > On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: > > Weird that I receive your each message twice. > > Once message You get from mailing list, one because You are (B)CC. If it is continues to be a problem go to : http://www.post

Re: [GENERAL] Weird problem that enormous locks

lipca 2011 03:51 To: Scott Marlowe Cc: PostgreSQL Subject: Re: [GENERAL] Weird problem that enormous locks On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote: On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > wrote: On Wed, Jul 13, 2011 at 9

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 5:08 AM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 18:52, Radosław Smogura > wrote: >> >> On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: >>> >>> Weird that I receive your each message twice. >> >> Once message You get from mailing list, one because You are (B)CC. >

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 18:52, Radosław Smogura wrote: > On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: > >> Weird that I receive your each message twice. >> > Once message You get from mailing list, one because You are (B)CC. > gmail should be clever enough handling that, at lease I didn't

Re: [GENERAL] Weird problem that enormous locks

t; >> >> >>> Regards, >>> Radoslaw Smogura >>> (mobile) >>> ----- >>> From: Tony Wang >>> Sent: 15 lipca 2011 03:51 >>> To: Scott Marlowe >>> Cc: PostgreSQL >>> >

Re: [GENERAL] Weird problem that enormous locks

On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote: Weird that I receive your each message twice. Once message You get from mailing list, one because You are (B)CC. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql

Re: [GENERAL] Weird problem that enormous locks

locks that relname is null. will add that, though no idea why its null   Regards, Radoslaw Smogura (mobile) - From: Tony Wang Sent: 15 lipca 2011 03:51 To: Scott Marlowe Cc: PostgreSQL Subject: Re: [GENERAL] Weird problem that enormous locks On

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 4:36 AM, Tony Wang wrote: > Weird that I receive your each message twice. > On Fri, Jul 15, 2011 at 15:33, Radoslaw Smogura > wrote: >> >> Simple and obvious question right now do You call commit after >> transaction? If yes do you use any query or connection pooler? > > Y

Re: [GENERAL] Weird problem that enormous locks

d that, though no idea why it's null > > > Regards, > Radoslaw Smogura > (mobile) > -- > From: Tony Wang > Sent: 15 lipca 2011 03:51 > To: Scott Marlowe > Cc: PostgreSQL > > Subject: Re: [GENERAL] Weird pro

Re: [GENERAL] Weird problem that enormous locks

: Re: [GENERAL] Weird problem that enormous locks On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote: On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > wrote: >> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: >> &

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 12:38, John R Pierce wrote: > On 07/14/11 7:58 PM, Tony Wang wrote: > >> >> There were 2519 RowExclusiveLock and 85 ExclusiveLock >> > > how could 800 max_connections have 2519 row locks ? do you update multiple > different rows in the same transaction? > > the row locks

Re: [GENERAL] Weird problem that enormous locks

On 07/14/11 7:58 PM, Tony Wang wrote: There were 2519 RowExclusiveLock and 85 ExclusiveLock how could 800 max_connections have 2519 row locks ? do you update multiple different rows in the same transaction? -- john r pierceN 37, W 122 santa cruz ca

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 10:42, Scott Marlowe wrote: > On Thu, Jul 14, 2011 at 8:28 PM, Tony Wang wrote: > > On Fri, Jul 15, 2011 at 10:05, Scott Marlowe > > wrote: > >> > >> On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: > >> > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe > > >> > wrote: >

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 8:28 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 10:05, Scott Marlowe > wrote: >> >> On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: >> > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe >> > wrote: >> >> >> >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: >> >> >

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 10:05, Scott Marlowe wrote: > On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: > > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe > > wrote: > >> > >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > >> > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > > >> > wrote: >

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 7:51 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 08:22, Scott Marlowe > wrote: >> >> On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: >> > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe >> > wrote: >> >> >> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: >> >> >

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 08:22, Scott Marlowe wrote: > On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > > wrote: > >> > >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: > >> > On Thu, Jul 14, 2011 at 10:35, John R Pierce > >> > wrote: > >>

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 6:01 PM, Tony Wang wrote: > On Fri, Jul 15, 2011 at 01:13, Scott Marlowe > wrote: >> >> On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: >> > On Thu, Jul 14, 2011 at 10:35, John R Pierce >> > wrote: >> > It's a game server, and the queries are updating users' money, as

Re: [GENERAL] Weird problem that enormous locks

On Fri, Jul 15, 2011 at 01:13, Scott Marlowe wrote: > On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: > > On Thu, Jul 14, 2011 at 10:35, John R Pierce > wrote: > > It's a game server, and the queries are updating users' money, as normal. > > The sql is like "UPDATE player SET money = money + 1

Re: [GENERAL] Weird problem that enormous locks

On Wed, Jul 13, 2011 at 9:47 PM, Tony Wang wrote: > On Thu, Jul 14, 2011 at 10:35, John R Pierce wrote: > It's a game server, and the queries are updating users' money, as normal. > The sql is like "UPDATE player SET money = money + 100 where id = 12345". > The locks were RowExclusiveLock for the

Re: [GENERAL] Weird problem that enormous locks

t's > the way why we think about having 9.x server. > > > Regards, > Radoslaw Smogura > (mobile) > -- > From: Tony Wang > Sent: 14 lipca 2011 07:00 > To: John R Pierce > Cc: pgsql-general@postgresql.org > Su

Re: [GENERAL] Weird problem that enormous locks

From: Tony Wang Sent: 14 lipca 2011 07:00 To: John R Pierce Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Weird problem that enormous locks On Thu, Jul 14, 2011 at 12:35, John R Pierce wrote: On 07/13/11 8:47 PM, Tony Wang wrote: It's a game server, and the queries are updating u

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 12:35, John R Pierce wrote: > On 07/13/11 8:47 PM, Tony Wang wrote: > >> It's a game server, and the queries are updating users' money, as normal. >> The sql is like "UPDATE player SET money = money + 100 where id = 12345". >> The locks were RowExclusiveLock for the table

Re: [GENERAL] Weird problem that enormous locks

On 07/13/11 8:47 PM, Tony Wang wrote: It's a game server, and the queries are updating users' money, as normal. The sql is like "UPDATE player SET money = money + 100 where id = 12345". The locks were RowExclusiveLock for the table "player" and the indexes. The weird thing is there was another

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 10:35, John R Pierce wrote: > On 07/13/11 7:16 PM, Tony Wang wrote: > > On Thu, Jul 14, 2011 at 10:01, John R Pierce > pie...@hogranch.com>> wrote: >> >>On 07/13/11 6:55 PM, Tony Wang wrote: >> >>Could I consider it a hardware problem, or postgresql running >>

Re: [GENERAL] Weird problem that enormous locks

On 07/13/11 7:16 PM, Tony Wang wrote: On Thu, Jul 14, 2011 at 10:01, John R Pierce > wrote: On 07/13/11 6:55 PM, Tony Wang wrote: Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a mo

Re: [GENERAL] Weird problem that enormous locks

On Thu, Jul 14, 2011 at 10:01, John R Pierce wrote: > On 07/13/11 6:55 PM, Tony Wang wrote: > >> Could I consider it a hardware problem, or postgresql running too long >> which causes problems? (It ran about half a month, however, it ran much >> longer than that without problems) >> > > i have po

Re: [GENERAL] Weird problem that enormous locks

On 07/13/11 6:55 PM, Tony Wang wrote: Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a month, however, it ran much longer than that without problems) i have postgres servers that run for months and even years without problems.

Re: [GENERAL] Weird problem that enormous locks

Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a month, however, it ran much longer than that without problems) On Wed, Jul 13, 2011 at 00:52, Tony Wang wrote: > Hi, > > The configuration information is listed at the end. > I met

Re: [GENERAL] Weird problem that enormous locks

On Wed, Jul 13, 2011 at 08:40, Craig Ringer wrote: > On 13/07/2011 12:52 AM, Tony Wang wrote: > >> Have any one experienced that, or any suggestion on researching/debugging? >> >> Capture the contents of pg_catalog.pg_stat_activity whenever your cron > job notices high lock counts. That'll give y

Re: [GENERAL] Weird problem that enormous locks

On 13/07/2011 12:52 AM, Tony Wang wrote: Have any one experienced that, or any suggestion on researching/debugging? Capture the contents of pg_catalog.pg_stat_activity whenever your cron job notices high lock counts. That'll give you some more information to work with. POST Newspapers 276 On