pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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







view thread (3+ messages)  latest in thread

Message-ID: <web-86804@davinci.ethosmedia.com>
Permalink:  ../web-86804@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-86804@davinci.ethosmedia.com

 · 

reply

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