X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 09BA052896 for ; Mon, 6 Jun 2005 11:25:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91166-09 for ; Mon, 6 Jun 2005 14:25:26 +0000 (GMT) Received: from mail.aknet.kg (aknet.kg [212.112.96.1]) by svr1.postgresql.org (Postfix) with ESMTP id DFD6C528D0 for ; Mon, 6 Jun 2005 11:25:18 -0300 (ADT) Received: (qmail 23518 invoked by uid 91); 6 Jun 2005 14:25:17 -0000 Received: from 212.112.107.15 by mail.aknet.kg (envelope-from , uid 82) with qmail-scanner-1.23st (spamassassin: 2.64. perlscan: 1.23st. Clear:RC:1(212.112.107.15):. Processed in 0.030326 secs); 06 Jun 2005 14:25:17 -0000 X-Qmail-Scanner-Mail-From: skyer@on.kg via mail.aknet.kg X-Qmail-Scanner: 1.23st (Clear:RC:1(212.112.107.15):. Processed in 0.030326 secs Process 23513) Received: from unknown (HELO MainComputer) (212.112.107.15) by mail.aknet.kg with SMTP; 6 Jun 2005 14:25:16 -0000 Date: Mon, 6 Jun 2005 20:25:31 +0400 From: "ON.KG" X-Mailer: The Bat! (v2.01) Reply-To: "ON.KG" Organization: UnCLouds X-Priority: 3 (Normal) Message-ID: <17434586625.20050606202531@on.kg> To: pgsql-sql Subject: What is faster? In-Reply-To: <42A43791.7030306@archonet.com> References: <42A43791.7030306@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/79 X-Sequence-Number: 21680 Hi All! What is faster - SLECTion data from one large table (200 000 - 300 000 records), or SELECTion from a few small tables (example, 2 tables 150 000 records each)? Thank You