Holger Marzen <[EMAIL PROTECTED]> writes:
> But many users compain about PostgreSQL's poor count(*) performance,
I don't think that's relevant here. Some other DB's have shortcuts for
determining the total number of rows in a single table, that is they can
do "SELECT COUNT(*) FROM a_table" quickl
On Sat, Sep 27, 2003 at 10:42:02PM -0300, Marc G. Fournier wrote:
> On Sat, 27 Sep 2003, Ron Johnson wrote:
>
> > Isn't Perl pretty ubiquitous on "Unix" now, though? Except maybe
> > Unixware
>
> I know that Solaris now has it included by default ...
FWIW, FreeBSD just removed it (in the 5.
On Sat, 27 Sep 2003, David Griffiths wrote:
>
> We are doing some performance testing among various databases (Oracle, MySQL
> and Postgres).
>
> One of the queries is showing Postgres lagging quite a bit:
>
> SELECT count(*)
> FROM commercial_entity, country, user_account, address_list
> LEFT JOI
On Sunday 28 September 2003 09:19, David Griffiths wrote:
> No difference. Note that all the keys that are used in the joins are
> numeric(10)'s, so there shouldn't be any cast-issues.
Can you make them bigint and see? It might make some difference perhaps.
Checking the plan in the meantime.. BTW
On Sunday 28 September 2003 09:36, Ron Johnson wrote:
> On Sat, 2003-09-27 at 22:19, Dennis Gearon wrote:
> > Ron Johnson wrote:
> > >There's always the general point that C has more pitfalls (mainly
> > >from pointers/free()/malloc(), and HLLs do more for you, thus you
> > >have to code less, and,