Re: getting count for a specific querry - Mailing list pgsql-sql

From Joel Fradkin
Subject Re: getting count for a specific querry
Date
Msg-id 000001c53c5d$9f07f0d0$797ba8c0@jfradkin
Whole thread Raw
In response to Re: getting count for a specific querry  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: getting count for a specific querry  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-sql
Thanks all.
I might have to add a button to do the count on command so they don't get
the hit.
I would want it to return the count of the condition, not the currently
displayed number of rows.

Is there any other database engines that provide better performance?
(We just 2 moths moving to postgres and it is not live yet, but if I am
going to get results back slower then my 2 proc box running MSSQL in 2 gig
and 2 processor I cant see any reason to move to it)
The Postgres is on a 4 proc Dell with 8 gigs of memory.
I thought I could analyze our queries and our config to optimize.


Joel Fradkin




pgsql-sql by date:

Previous
From: Ragnar Hafstað
Date:
Subject: Re: getting count for a specific querry
Next
From: Vivek Khera
Date:
Subject: Re: Question on triggers and plpgsql