[ADMIN] kerberos

2004-12-27 Thread Sean Brown
Does postgresql 7.4 only support linking to MIT kerberos and not Heimdal, or did I make a mistake building it. ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] Cluster/Replication

2007-10-19 Thread Sean Brown
I believe this has come up before, and I am still researching how to do this and figured asking was probably a good idea as hopefully I can either get some direction or someone can point me at something I haven't seen yet. We are setting up a new database system that is going to act as our

[ADMIN] Number of Current Client Connections

2008-11-10 Thread Sean Brown
Is there a query I can run against PostgreSQL to get the number of current client connections to the database? I didn't expect trying to track this down would be as difficult as it has been. Would a simple count of pg_stat_activity be correct? -Thanks signature.asc Description: This is a digita

Re: [ADMIN] function executes sql 100 times longer it should

2008-11-12 Thread Sean Brown
On Wed, 2008-11-12 at 16:10 +0200, Julius Tuskenis wrote: > Hello, list. > > I have one simple SQL function returning result set that takes around 3 > seconds to execute. But if I execute the Select it executes directly - > it takes only around 30 ms. Why so big difference? Probably caching the