From: Joel Fradkin <jfradkin@wazagua.com>
To: 'Andrew Sullivan' <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: getting count for a specific querry
Date: Fri, 08 Apr 2005 13:08:44 -0400
Message-ID: <000001c53c5d$9f07f0d0$797ba8c0@jfradkin> (raw)
In-Reply-To: <20050408163039.GE27718@phlogiston.dyndns.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jfradkin@wazagua.com, ajs@crankycanuck.ca
Subject: Re: getting count for a specific querry
In-Reply-To: <000001c53c5d$9f07f0d0$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox