From: Josh Berkus <josh@agliodbs.com>
To: Nikola Ivacic <nikola@rs-pi.com>
To: Ian Harding <ianh@tpchd.org>
Cc: pgsql-sql@postgresql.org
Subject: Re: count(*) optimization
Date: Wed, 08 Jan 2003 09:44:19 -0800
Message-ID: <web-2307493@davinci.ethosmedia.com> (raw)
In-Reply-To: <02cd01c2b738$39cc0a00$1100a8c0@rspi>
Nikola,
> I am not sure pgAdmin uses count(*) and I didn't have time to check
> phpPgAdmin also, I presumed it from similarly slow response I get in
> psql
Well, pgAdmin and phpPgAdmin have their own mailing lists. I'd suggest
posting there. Ideally, these programs should have an option that
lets you use the Analyze stats instead of a real count if you want
speed over accuracy. If nobody requests it, though, neither
development team is likely to consider it.
Of course, it's also possible that these interfaces are slow for lots
of other reasons. For example, I've found pgAdminII to be sluggish on
a large, busy network because MS-ODBC is quite vulnerable to traffic
conflicts. And phpPgAdmin, at least several versions ago, had a
tendency to issue a seperate query for each single bit of information,
mySQL-style (they may have fixed this, though).
-Josh Berkus
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: josh@agliodbs.com, nikola@rs-pi.com, ianh@tpchd.org
Subject: Re: count(*) optimization
In-Reply-To: <web-2307493@davinci.ethosmedia.com>
* 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