Re: [ADMIN] how to create cluster(loadbanacing) of postgresql server

2008-01-30 Thread Markus Schiltknecht
Hi, yogesh m chaudhari wrote: Can any Guys help me to create postgresql Cluster. Is there any useful link or Info. related to cluster than pl mail me. There are various possibilities, for a good start, check the official docu: http://www.postgresql.org/docs/8.2/static/high-availability.html

[ADMIN] connection from connection pool uses too much memory during the time

2008-01-30 Thread Honza Novak
Hello, I've come across this problem: We have some tomcats connecting to postgresql database using connection pools, which means, that connection gets open while tomcat first uses it and then stays open, until we stop tomcat. So far everything is fine, connection pooling works nicely. But. We

Re: [ADMIN] connection from connection pool uses too much memory during the time

2008-01-30 Thread Kevin Grittner
>>> On Wed, Jan 30, 2008 at 3:53 AM, in message <[EMAIL PROTECTED]>, Honza Novak <[EMAIL PROTECTED]> wrote: > The problem is that it looks > like, that once the open connection takes some memory, it never gives > that memory back, which ends up with our server swapping large amounts > of mem

Re: [ADMIN] [GENERAL] Can we have 2 databases on same server

2008-01-30 Thread Chander Ganesan
Hello Suresh, Suresh Gupta VG wrote: Hi Team, I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I don't want to disturb the first version now. I want to install second one separately and need to test with my application. If it works fine, I will activate only the late

[ADMIN] monitoring fragmentation

2008-01-30 Thread Kasia Tuszynska
Hi Everybody, I am searching for a pg_x view that would allow me to view the properties of an index. - the fillfactor it was created with - the amount of free space on a page(s) storing the index ( assuming that it was created with a fillfactor and the index has incurred updates since the cre

Re: [ADMIN] monitoring fragmentation

2008-01-30 Thread Guillaume Lelarge
Kasia Tuszynska wrote: I am searching for a pg_x view that would allow me to view the properties of an index. - the fillfactor it was created with Catalog pg_class, column reloptions. - the amount of free space on a page(s) storing the index ( assuming that it was created with a fillfact