Re: Postgres on SSD
От | Ondrej Ivanič |
---|---|
Тема | Re: Postgres on SSD |
Дата | |
Msg-id | CAM6mie+A4j4SUBv+g=KJzAZyTR4oQ5_EE3S7bcSj3E+2WTOmnw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Postgres on SSD ("Tomas Vondra" <tv@fuzzy.cz>) |
Ответы |
Re: Postgres on SSD
Re: Postgres on SSD |
Список | pgsql-general |
Hi, 2011/8/10 Tomas Vondra <tv@fuzzy.cz>: > On 10 Srpen 2011, 1:17, Ondrej Ivanič wrote: >> - What needs to be changed at Postgres/Operating system level? The >> obvious one is to change random_page_cost (now: 2) and seq_page_cost >> (now: 4). What else should I look at? > > Are you sure about this? I'm not quite sure setting seq_page_cost=4 and > random_page_cost=2 makes sense. Usually seq_page_cost is lower than > random_page_cost, so I wonder why have you set it like that. Ups! Well spotted Tomas! The actual values are: random_page_cost = 2 seq_page_cost = 1 -- Ondrej Ivanic (ondrej.ivanic@gmail.com)
В списке pgsql-general по дате отправления: