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 F38E2D1D08B for ; Tue, 13 Apr 2004 15:35:26 -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 35890-02 for ; Tue, 13 Apr 2004 15:35:26 -0300 (ADT) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 93FC0D1D08A for ; Tue, 13 Apr 2004 15:35:24 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id i3DIbrcM010790; Tue, 13 Apr 2004 14:37:53 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id i3DIZHl07552; Tue, 13 Apr 2004 14:35:17 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id FVMA9A4C; Tue, 13 Apr 2004 14:35:15 -0400 Subject: Re: index v. seqscan for certain values From: Robert Treat To: jdunn@autorevenue.com Cc: "'Postgresql Performance'" In-Reply-To: <000f01c42181$be1b6260$4f01a8c0@jeremydunn> References: <000f01c42181$be1b6260$4f01a8c0@jeremydunn> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 13 Apr 2004 14:35:16 -0400 Message-Id: <1081881316.25537.562.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/152 X-Sequence-Number: 6452 On Tue, 2004-04-13 at 14:04, Jeremy Dunn wrote: > > > 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? > transform=# alter table data_pull alter column msg set statistics 100000; WARNING: lowering statistics target to 1000 ERROR: column "msg" of relation "data_pull" does not exist transform=# select version(); version ---------------------------------------------------------------- PostgreSQL 7.4beta4 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL