Feature request: ALTER TABLE tbl SET STATISTICS...

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: PGBugs List <pgsql-bugs(at)postgresql(dot)org>
Subject: Feature request: ALTER TABLE tbl SET STATISTICS...
Date: 2004-12-07 07:51:14
Message-ID: C53CEC53-4824-11D9-9EB9-000A95C705DC@chittenden.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Subject nearly says it all. Could we add it to the TODO list to have
per table statistics? I have a table here that requires a stats target
of 1000 in order for it to project values correctly (believe me, tried
everything in increments of 50 from 10 on up, it needs 1000). The
problem being that the rest of the database works just fine with a
statistics target of 20. Using per-column stats works, but was kind of
tedious to setup (there are ~20 active columns that need that high of a
stats value). Anyway, something along the lines of:

ALTER TABLE tbl SET STATISTICS 1000;

would be fantastic. Thanks. -sc

--
Sean Chittenden

Browse pgsql-bugs by date

  From Date Subject
Next Message yoursoft@freemail.hu 2004-12-07 07:55:54 PostgreSQL memory bug
Previous Message PostgreSQL Bugs List 2004-12-07 02:13:57 BUG #1343: Problem with German Umlaut in the installer