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 7F430D1B8BB for ; Thu, 4 Sep 2003 11:02:08 +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 24076-10 for ; Thu, 4 Sep 2003 08:02:00 -0300 (ADT) Received: from fuji.krosing.net (silmet.estpak.ee [194.126.97.78]) by svr1.postgresql.org (Postfix) with ESMTP id 23820D1B8A3 for ; Thu, 4 Sep 2003 08:01:57 -0300 (ADT) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h84B1tDN005704; Thu, 4 Sep 2003 14:01:55 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h84B1sb8005702; Thu, 4 Sep 2003 14:01:54 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: SELECT's take a long time compared to other DBMS From: Hannu Krosing To: Relaxin Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1062673303.5200.135.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 04 Sep 2003 14:01:53 +0300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/58 X-Sequence-Number: 3424 Relaxin kirjutas N, 04.09.2003 kell 03:28: > I have a table with 102,384 records in it, each record is 934 bytes. I created a test database on my Linux (RH9) laptop with 30GB/4200RPM ide drive and P3-1133Mhz, 768MB, populated it with 128000 rows of 930 bytes each and did [hannu@fuji hannu]$ time psql test100k -c 'select * from test' > /dev/null real 0m3.970s user 0m0.980s sys 0m0.570s so it seems definitely not a problem with postgres as such, but perhaps with Cygwin and/or ODBC driver I also ran the same query using the "standard" pg adapter: >>> import pg, time >>> >>> con = pg.connect('test100k') >>> >>> def getall(): ... t1 = time.time() ... res = con.query('select * from test') ... t2 = time.time() ... list = res.getresult() ... t3 = time.time() ... print t2 - t1, t3-t2 ... >>> getall() 3.27637195587 1.10105705261 >>> getall() 3.07413101196 0.996125936508 >>> getall() 3.03377199173 1.07322502136 which gave similar results ------------------------------ Hannu