[PERFORM] large number of connected connections to postgres database (v8.0)

2007-07-17 Thread Fei Liu
It appears my multi-thread application (100 connections every 5 seconds) is stalled when working with postgresql database server. I have limited number of connections in my connection pool to postgresql to 20. At the begining, connection is allocated and released from connection pool as postgre

Re: [PERFORM] Query performance problems with partitioned tables

2007-05-08 Thread Fei Liu
Scott Marlowe wrote: On Thu, 2007-05-03 at 21:37, Merlin Moncure wrote: On 5/3/07, Fei Liu <[EMAIL PROTECTED]> wrote: Hello, Andreas, I too am having exactly the same issue as you do. Comparing my partitioned and plain table performance, I've found that the plain tables pe

Re: [PERFORM] Query performance problems with partitioned tables

2007-05-03 Thread Fei Liu
Andreas Haumer wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I'm currently experimenting with PostgreSQL 8.2.4 and table partitioning in order to improve the performance of an application I'm working on. My application is about managing measurement values (lots of!) I have one table

[PERFORM] sytem log audit/reporting and psql

2007-04-30 Thread Fei Liu
Hello group, I need to design and develop a web reporting system to let users query/view syslog files on a unix host. For now, I am concentrating on the authentication file that has user logon (success/failure) and logoff records. The log file is logrotated every week or so. My reporting system