From:
Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Greg Stark <gsstark(at)mit(dot)edu>, Josh Berkus <josh(at)agliodbs(dot)com>,Robert Haas <robertmhaas(at)gmail(dot)com>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: per-tablespace random_page_cost/seq_page_cost
Date:
2009-10-26 23:52:53
Message-ID:
20091026235253.GO8812@alvh.no-ip.org (view raw or flat )
Thread:
2009-10-25 16:05:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-10-26 16:09:27 from Greg Stark <gsstark(at)mit(dot)edu>
2009-10-26 22:05:20 from Josh Berkus <josh(at)agliodbs(dot)com>
2009-10-26 23:35:24 from Greg Stark <gsstark(at)mit(dot)edu>
2009-10-26 23:42:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-10-26 23:47:56 from Andres Freund <andres(at)anarazel(dot)de>
2009-10-27 03:07:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-10-28 00:50:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-10-28 01:13:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-10-28 01:20:54 from David Fetter <david(at)fetter(dot)org>
2009-10-28 02:01:54 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-10-28 02:10:46 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-10-28 02:18:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-10-28 02:58:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-01 02:04:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-01 12:43:57 from Greg Stark <gsstark(at)mit(dot)edu>
2009-11-01 15:02:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-02 21:11:33 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-02 21:34:43 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-02 21:34:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-03 12:44:57 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2009-11-03 13:37:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-02 17:40:16 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-03 04:03:42 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-03 11:25:46 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-03 12:49:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-11-03 12:51:52 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-11-03 13:37:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-10-26 23:52:53 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2009-10-27 15:16:55 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
Lists:
pgsql-hackers
Tom Lane escribió:
> Greg Stark <gsstark(at)mit(dot)edu> writes:
> > Still far from convinced on that one. But effective_io_concurrency
> > should be included even in the first pass.
>
> I think a design that is limited to a prespecified set of GUCs is
> broken by definition. It'd be better to make it work like
> ALTER DATABASE SET.
Well, not exactly like ALTER DATABASE SET because those are now stored
in pg_db_role_setting. But a new spcoptions column storing an array of
key/value pairs seems a reasonable way to do it.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
In response to
Responses
pgsql-hackers by date
Next :From: Itagaki TakahiroDate: 2009-10-27 00:20:46Subject : Re: "toast.fillfactor" is documented but not recognized?Previous :From : Andres FreundDate : 2009-10-26 23:47:56Subject : Re: per-tablespace random_page_cost/seq_page_cost
