X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 317B4329E01 for ; Tue, 5 Oct 2004 00:34:44 +0100 (BST) 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 01525-02 for ; Mon, 4 Oct 2004 23:34:38 +0000 (GMT) Received: from trofast.sesse.net (trofast.sesse.net [129.241.93.32]) by svr1.postgresql.org (Postfix) with ESMTP id 95EC2329DF7 for ; Tue, 5 Oct 2004 00:34:37 +0100 (BST) Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1CEcLk-0003UO-00 for ; Tue, 05 Oct 2004 01:34:36 +0200 Date: Tue, 5 Oct 2004 01:34:36 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: would number of fields in a table affect search-query time? Message-ID: <20041004233436.GB13394@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <59b2d39b0410041627d405f39@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <59b2d39b0410041627d405f39@mail.gmail.com> X-Operating-System: Linux 2.6.6 on a i686 User-Agent: Mutt/1.5.6+20040818i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/38 X-Sequence-Number: 8514 On Mon, Oct 04, 2004 at 04:27:51PM -0700, Miles Keaton wrote: > would the number of fields in a table significantly affect the > search-query time? More fields = larger records = fewer records per page = if you read in everything, you'll need more I/O. > I have this database table of items with LOTS of properties per-item, > that takes a LONG time to search. It's a bit hard to say anything without seeing your actual tables and queries; I'd guess you either have a lot of matches or you're doing a sequential scan. You might want to normalize your tables, but again, it's hard to say anything without seeing your actual data. /* Steinar */ -- Homepage: http://www.sesse.net/