Re: [GENERAL] Concurrency issue under very heay loads

2009-07-20 Thread Raji Sridar (raji)
9-07-17 14:10:59 4736 970134 LOG: duration: 0.000 ms 2009-07-17 14:10:59 4736 970134 STATEMENT: UPDATE tableEntityID SET nextEntityID = $1 WHERE entityType = $2 2009-07-17 14:10:59 4736 970134 DEBUG: ProcessQuery 2009-07-17 14:10:59 4736 970134 STATEMENT: UPDATE tableEntityID SET nextEntityID = $1 WHERE entity

Help needed for reading postgres log : RE: [GENERAL] Concurrency issue under very heay loads

2009-07-20 Thread Raji Sridar (raji)
= $1 WHERE entityType = $2 2009-07-17 14:10:59 4736 970134 LOG: duration: 0.000 ms 2009-07-17 14:10:59 4736 970134 STATEMENT: UPDATE tableEntityID SET nextEntityID = $1 WHERE entityType = $2 2009-07-17 14:10:59 4736 970134 DEBUG: ProcessQuery 2009-07-17 14:10:59 4736 970134 STATEMENT: UPDATE tab

Re: [GENERAL] Concurrency issue under very heay loads

2009-07-17 Thread Raji Sridar (raji)
2-506. Thanks Raji -Original Message- From: Greg Smith [mailto:gsm...@gregsmith.com] Sent: Thursday, July 16, 2009 2:03 PM To: Raji Sridar (raji) Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Concurrency issue under very heay loads On Wed, 15 Jul 2009, Raji Sridar (raji) wrote: &

[GENERAL] Concurrency issue under very heay loads

2009-07-15 Thread Raji Sridar (raji)
Hi, We use a typical counter within a transaction to generate order sequence number and update the next sequence number. This is a simple next counter - nothing fancy about it. When multiple clients are concurrently accessing this table and updating it, under extermely heavy loads in the syst

Re: [GENERAL] Postgres 8.2.x support on Windows 2008

2009-03-16 Thread Raji Sridar (raji)
Raji Sridar (raji) Cc: Scott Marlowe; r...@iol.ie; pgsql-general@postgresql.org Subject: RE: [GENERAL] Postgres 8.2.x support on Windows 2008 On Mon, 2009-03-16 at 18:12 -0700, Raji Sridar (raji) wrote: > Thanks for the prompt responses. None of the urls mention Windows 2008. > Looks lik

Re: [GENERAL] Postgres 8.2.x support on Windows 2008

2009-03-16 Thread Raji Sridar (raji)
...@commandprompt.com Cc: r...@iol.ie; Raji Sridar (raji); pgsql-general@postgresql.org Subject: Re: [GENERAL] Postgres 8.2.x support on Windows 2008 On Mon, Mar 16, 2009 at 4:58 PM, Joshua D. Drake wrote: > On Mon, 2009-03-16 at 22:55 +, Raymond O'Donnell wrote: >> On 16/03/2009 22:4

[GENERAL] Postgres 8.2.x support on Windows 2008

2009-03-16 Thread Raji Sridar (raji)
Hi, I would like to know if Postgres 8.2.x is supported on Windows 2008 (32 bit). If not, what is version of Postgres supported on Windows 2008? PLs let me know. Thanks Raji -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.p