On Mon, Apr 27, 2020 at 12:16:30PM -0400, Bruce Momjian wrote:
> On Mon, Apr 27, 2020 at 06:02:41AM +0200, Pavel Stehule wrote:
> > > Storage that has a low random read cost relative to sequential, e.g.
> > solid-state drives, might also be better modeled with a value that is
> > close
>
On Mon, Apr 27, 2020 at 07:24:45PM +0300, Олег Самойлов
wrote:
> Yes, I saw recommendations for 1.1 early, but why? Why such exactly
> precision number, why 1.1? Is here ever a theoretical or experimental
> prof?
Well, SSD random performance is slightly slower than sequential, so the
value should
Yes, I saw recommendations for 1.1 early, but why? Why such exactly precision
number, why 1.1? Is here ever a theoretical or experimental prof?
As for me, random_page_cost depended not only not characteristic of a storage
device (hdd or ssd), but also on assumptions about how much of the databas
On Mon, Apr 27, 2020 at 06:02:41AM +0200, Pavel Stehule wrote:
>
>
> ne 26. 4. 2020 v 21:25 odesílatel yigong hu napsal:
>
> Sorry to hijack the thread, I also recently have similar observation that
> the statement about random_page_cost on SSD is ambiguous. The current
> document s
ne 26. 4. 2020 v 21:25 odesílatel yigong hu napsal:
> Sorry to hijack the thread, I also recently have similar observation that
> the statement about random_page_cost on SSD is ambiguous. The current
> document says that
>
> > Storage that has a low random read cost relative to sequential, e.g.
>
Sorry to hijack the thread, I also recently have similar observation that
the statement about random_page_cost on SSD is ambiguous. The current
document says that
> Storage that has a low random read cost relative to sequential, e.g.
solid-state drives, might also be better modeled with a lower va
Yep. Unclear. What parameter is recommended for SSD? Lower? 3? 2? 1?
Much better will be write: if you use SSD set 1.
Олег
> 19 марта 2020 г., в 23:56, Bruce Momjian написал(а):
>
> On Thu, Feb 27, 2020 at 02:48:44PM +, PG Doc comments form wrote:
>> The following documentation comment ha
On Thu, Feb 27, 2020 at 02:48:44PM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/12/runtime-config-query.html
> Description:
>
> Explanation for random_page_cost is rather outdated, because it did
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-query.html
Description:
Explanation for random_page_cost is rather outdated, because it did only for
case of mechanical hdd. But all modern database servers, which I know, m
