X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 40A75D1B94F for ; Thu, 4 Sep 2003 01:04:53 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 65959-09 for ; Wed, 3 Sep 2003 22:04:44 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 610BBD1B8F5 for ; Wed, 3 Sep 2003 22:04:40 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id DBDD61024D; Wed, 3 Sep 2003 20:56:38 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-83.tor.dsl.tht.net [134.22.133.83]) by mailav.tor1.inquent.com (Postfix) with ESMTP id ADF5010248; Wed, 3 Sep 2003 20:56:36 -0400 (EDT) Subject: Re: SELECT's take a long time compared to other DBMS From: Rod Taylor To: Relaxin Cc: Postgresql Performance In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-THlmMwF3Wvrr12QDRv6C" Message-Id: <1062637505.84923.7.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Wed, 03 Sep 2003 21:05:06 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/39 X-Sequence-Number: 3405 --=-THlmMwF3Wvrr12QDRv6C Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > Under PG: Data is returned in 26 secs!! > Under SQL Server: Data is returned in 5 secs. > Under SQLBase: Data is returned in 6 secs. > Under SAPDB: Data is returned in 7 secs. What did you use as the client? Do those times include ALL resulting data or simply the first few lines? PostgreSQL performance on windows (via Cygwin) is known to be poor. Do you receive similar results with 7.4 beta 2? --=-THlmMwF3Wvrr12QDRv6C Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/Vo/B6DETLow6vwwRApdeAJ9TuX1iudKEA4ZEhN39x5efP3S7DgCfdT7j b9iC6UYXwuKNmrGDOwEG3Ss= =EhzH -----END PGP SIGNATURE----- --=-THlmMwF3Wvrr12QDRv6C--