Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From
: Saurabh Nanda <saurabhnanda@xxxxxxxxx>
Date
: Mon, 28 Jan 2019 10:33:21 +0530
Cc
: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to
: <CAPz=2oEN1DRjhWLJNN112xO-vzSGff=Cqgs5oLw9W12y=NMtWw@mail.gmail.com>
References
: <CAPz=2oGdmvirLNX5kys+uiY7LKzCP4sTiXXob39qq6eDkEuk2Q@mail.gmail.com> <CAMkU=1yNvhDow9QvKeG5nzv2fDG9VXJ3gi8JbX2h0t8_MY1hBA@mail.gmail.com> <CAPz=2oF8C-JAny9eM_gNkzQDj1CDjGfoQ17rcHm5-N-hOFAhUg@mail.gmail.com> <CAPz=2oE7HBJo59ANsYoEwyJU3AbjXU1opu_p3MuYZbcja_LCAg@mail.gmail.com> <CAMkU=1wn1Hfm+wKxx1sRZ_hEVbt6M5yAVrxXYZA8+B8q2D7-Zg@mail.gmail.com> <CAPz=2oHb7W5QzBSt-aAkmFBwC7EAJGxV_0x5OKwA_QeMwZNtbQ@mail.gmail.com> <CAPz=2oEN1DRjhWLJNN112xO-vzSGff=Cqgs5oLw9W12y=NMtWw@mail.gmail.com>
All this benchmarking has led me to a philosophical question, why does PG need shared_buffers in the first place? What's wrong with letting the OS do the caching/buffering? Isn't it optimised for this kind of stuff?
Follow-Ups
:
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Jeff Janes
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Saurabh Nanda
References
:
Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Saurabh Nanda
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Saurabh Nanda
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Saurabh Nanda
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Jeff Janes
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Saurabh Nanda
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
From:
Saurabh Nanda
Prev by Date:
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Next by Date:
upgrade from 9.6 to 10/11
Previous by thread:
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Next by thread:
Re: Benchmarking: How to identify bottleneck (limiting factor) and achieve "linear scalability"?
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
