Re: The best - Mailing list pgsql-general

From Ron Johnson
Subject Re: The best
Date
Msg-id 1054581381.3398.151.camel@haggis
Whole thread Raw
In response to Re: The best  (Tony Grant <tony@tgds.net>)
List pgsql-general
On Mon, 2003-06-02 at 13:20, Tony Grant wrote:
> On Mon, 2003-06-02 at 18:28, scott.marlowe wrote:
>
> > MySQL is designed as a high speed data storage system with minimal
> > relational capabilities and almost non-existent contraint capabilities.
> ...
> > Since database speed has never been an issue for the stuff I do, I've
> > never needed to sacrifice the rich environment of Postgresql for the
> > faster one of MySQL in production.
>
> I would add to that - recent versions of PostgreSQL are not slow. And it
> makes a great back end for second generation webapps.
>
> Speed is no longer an issue.

When your join predicate "halves" both use the same datatype.

Also, the common aggregates are still pretty slow, not withstanding
the "hash aggregator" that should come out in 7.4 which still scans
the whole table instead of using supporting indexes.

--
+-----------------------------------------------------------+
| Ron Johnson, Jr.     Home: ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| Regarding war zones: "There's nothing sacrosanct about a  |
| hotel with a bunch of journalists in it."                 |
|     Marine Lt. Gen. Bernard E. Trainor (Retired)          |
+-----------------------------------------------------------+


pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: speed w/ OFFSET/LIMIT
Next
From: "Rod Cope"
Date:
Subject: [ANN] PostgreSQL included in Out-of-the-Box Open Source distribution