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:
> >>
>
On Fri, Jul 15, 2011 at 19:47, Radosław Smogura wrote:
> On Fri, 15 Jul 2011 19:07:45 +0800, Tony Wang wrote:
>
>> On Fri, Jul 15, 2011 at 18:50, Radosław Smogura wrote:
>>
>> On Fri, 15 Jul 2011 18:36:19 +0800, Tony Wang wrote:
>>>
>>> We
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 h
On Fri, Jul 15, 2011 at 18:50, Radosław Smogura wrote:
> On Fri, 15 Jul 2011 18:36:19 +0800, 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 q
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
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 sa
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,
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,
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 1
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 lik
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
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".
>> T
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
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
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 think logs may help. Have you checked that?
2011/7/13 Andrus
> Sometimes per week server stops randomly responding for approx 5 minutes.
> User should wait for 5 minutes before server responds.
> Other users can work normally at same time.
>
> Monday this happens at 12:16
> I havent noticed
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 hig
IO drive
Memory: 32G
Postgresql configuration:
max_connection = 800
shared_buffers = 2000MB
effective_cache_size = 14000MB
autovacuum = off
--
BR,
Tony Wang
18 matches
Mail list logo