Re: [GENERAL] Postgres Performance Issue

2007-07-20 Thread Bill Moran
In response to Brian Maguire <[EMAIL PROTECTED]>: > Hi, > > We're trying to figure out why we're getting poor query performance on a > particular database running on a 64 bit Solaris box. The info for the poor > database is: > > Red Hat Enterprise Linux AS release 4 (Nahant Update 2) Linux vl

[GENERAL] Postgres Performance Issue

2007-07-20 Thread Brian Maguire
Hi, We're trying to figure out why we're getting poor query performance on a particular database running on a 64 bit Solaris box. The info for the poor database is: Red Hat Enterprise Linux AS release 4 (Nahant Update 2) Linux vl-sfv40z-001 2.6.9-22.0.2.ELsmp #1 SMP Thu Jan 5 17:11:56 EST 200

[GENERAL] Postgres performance issue

2001-05-28 Thread Linh Luong
Hi Everyone, I am running Postgres 7.1 and php 4.0. I have a question: Why does postmaster use 80% of the CPU on a simple sql query? I have a form that displays a list of customers based on a criteria they enter. If the user doesn't enter in a criteria it will display all the customer in th