From: Josh Berkus <josh@agliodbs.com>
To: Mark kirkwood <markir@slingshot.co.nz>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: How Postgresql Compares For Some Query Types
Date: Tue, 17 Jul 2001 08:18:12 -0700
Message-ID: <web-86804@davinci.ethosmedia.com> (raw)
In-Reply-To: <01071223501800.01909@spikey.slithery.org>
Mark, (and Tom below)
Thanks for doing the tests. These'll be useful to me if any client
asks me again if PostgreSQL is a "real" database. I'm particularly
intrigued that MySQL performed so poorly. In the field, it's been quite
speedy but maybe that's because applications using it are restricted to
simple queries.
You may wish to post your link to Slashdot and pgsql-announce as well.
I'm sure the Great Bridge folks will be interested.
I'm a little unclear on what a "fact table" is. Can you explain?
Finally, Tom, I figured out what was up with the 30-45 second response
time on the large star query I couldn't get to perform. Turns out that
the client had changed two of the VARCHAR fields to TEXT fields and
added large blocks of text (> 16k for some) to them. When I removed
these fields from the query, it gives me the <7s response time I'd
expected.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
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, markir@slingshot.co.nz
Subject: Re: How Postgresql Compares For Some Query Types
In-Reply-To: <web-86804@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