Re: How Postgresql Compares For Some Query Types

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