Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6HFIMa01299 for ; Tue, 17 Jul 2001 11:18:22 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 86804; Tue, 17 Jul 2001 08:18:12 -0700 From: "Josh Berkus" Subject: Re: How Postgresql Compares For Some Query Types To: Mark kirkwood , "pgsql-sql@postgresql.org" X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Tue, 17 Jul 2001 08:18:12 -0700 Message-ID: In-Reply-To: <01071223501800.01909@spikey.slithery.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="_===86804====davinci.ethosmedia.com===_" X-Archive-Number: 200107/222 X-Sequence-Number: 4018 This is a multi-part MIME message --_===86804====davinci.ethosmedia.com===_ Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit 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 --_===86804====davinci.ethosmedia.com===_ Content-Type: text/plain Content-Disposition: attachment; filename="" Content-Transfer-Encoding: base64 DQo= --_===86804====davinci.ethosmedia.com===_ Content-Type: text/plain Content-Disposition: attachment; filename="" Content-Transfer-Encoding: base64 DQo= --_===86804====davinci.ethosmedia.com===_ Content-Type: text/plain Content-Disposition: attachment; filename="" Content-Transfer-Encoding: base64 DQo= --_===86804====davinci.ethosmedia.com===_--