Re: about some parameters
От | Jaime Casanova |
---|---|
Тема | Re: about some parameters |
Дата | |
Msg-id | 3073cc9b1001022300m4cd0b826i7f4e79b2a81b7b26@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: about some parameters (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Fri, Jan 1, 2010 at 12:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > >> another parameter that is interesting is seq_page_cost, AFAIUI all the >> other cost parameters (in the planner section of course) are relative >> to this one. so what is the logic in allow changing it? > > Please read the discussions that went on when we added that parameter. > digging the archives is alway an interesting sport, from this one i have learnt some things: 1) now i know was the meaning of GUC: Grand Unified Config (one mistery less) 2) that seq_page_cost was added when i was around here but apparently not looking 3) seems like the idea of this GUC started as a multiplier for all *_cost parameters but ended being just for random_page_cost 4) ... and that Tom has three hands (http://archives.postgresql.org/pgsql-hackers/2006-05/msg01346.php) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
В списке pgsql-hackers по дате отправления: