Re: [ADMIN] PGSQL-IDLE connection problem

hi, Thanks for the response.Here I have few more queries regarding Connections. 1.When the connection goes to state 2. when the connection becomes active 3.Is there any chance to database get slow because of connections Any help would be appreciated..

[ADMIN] PGSQL-IDLE connection problem

Hi, we had problem with connections.when we start the database there huge number of connections goes to which leads to database access slow. How can we prevent the connections and also where we can see the connection query so that we can identify.

Re: [ADMIN] [GENERAL] epqa; postgres performance optimizer support tool; opensource.

Sure , i 'll try with our database log Regards sathish On Tue, Nov 4, 2008 at 5:55 PM, sathiya psql <[EMAIL PROTECTED]> wrote: > Dear All, > > > Recently i have released the next version of the epqa. which is a very > useful tool for, gives input for optimizing psq

[ADMIN] doubt

dear groups, i have a doubt in sql, i have a table staff_skills in which i have set a table level constraint to create a primary key of two fields . so 'name' and 'skill' combinedly forms a primary key. now the issue is in another table i have only 'name' field and i want to create a fore

Re: [ADMIN] Problems while starting DB

semsys:seminfo_semmsl=32 Thanks Tom . -Sathish At 09:39 AM 10/22/2003 -0400, Tom Lane wrote: Sathish Somanathan <[EMAIL PROTECTED]> writes: > IpcSemaphoreCreate: semget(key=5432001, num=17, 03600) failed: Invalid argument It sounds like you don't have SysV semaphore support enabled, o

[ADMIN] Problems while starting DB

x27; -O2 -funroll-loops -fexpensive-optimizations -I/opt/CSCOets/pgsql/include' $ CPPFLAGS=`getconf LFS_CFLAGS`' -O2 -funroll-loops -fexpensive-optimizations -I/opt/CSCOets/pgsql/include' Any help with this would be appreciated. Thanks, -Sathish --