X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9948ED1E180 for ; Tue, 13 Apr 2004 15:04:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 19433-08 for ; Tue, 13 Apr 2004 15:04:25 -0300 (ADT) Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by svr1.postgresql.org (Postfix) with ESMTP id C7892D1CCA7 for ; Tue, 13 Apr 2004 15:04:21 -0300 (ADT) Received: from jeremydunn ([192.168.1.79]) (authenticated) by mail.autorevenue.com (8.11.6/8.11.6) with ESMTP id i3DI4LY31234 for ; Tue, 13 Apr 2004 14:04:21 -0400 Reply-To: From: "Jeremy Dunn" To: "'Postgresql Performance'" Subject: Re: index v. seqscan for certain values Date: Tue, 13 Apr 2004 14:04:19 -0400 Organization: AutoRevenue Message-ID: <000f01c42181$be1b6260$4f01a8c0@jeremydunn> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-reply-to: <24670.1081878949@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/151 X-Sequence-Number: 6451 > There's a hard limit of 1000, I believe. Didn't it give you > a warning saying so? No warning at 2000, and no warning at 100,000 either! Remember we are still on 7.2.x. The docs here http://www.postgresql.org/docs/7.2/static/sql-altertable.html don't say anything about a limit. This is good to know, if it's true. Can anyone confirm? - Jeremy