| From: | Vladimir Churyukin <vladimir(at)churyukin(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Bypassing shared_buffers |
| Date: | 2023-06-15 00:57:31 |
| Message-ID: | CAFSGpE3y_oMK1uHhcHxGxBxs+KrjMMdGrE+6HHOu0vttVET0UQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
There is often a need to test particular queries executed in the worst-case
scenario, i.e. right after a server restart or with no or minimal amount of
data in shared buffers. In Postgres it's currently hard to achieve (other
than to restart the server completely to run a single query, which is not
practical). Is there a simple way to introduce a GUC variable that makes
queries bypass shared_buffers and always read from storage? It would make
testing like that orders of magnitude simpler. I mean, are there serious
technical obstacles or any other objections to that idea in principle?
Thanks,
-Vladimir Churyukin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vladimir Churyukin | 2023-06-15 01:14:06 | Re: Bypassing shared_buffers |
| Previous Message | Michael Paquier | 2023-06-15 00:46:33 | Re: allow granting CLUSTER, REFRESH MATERIALIZED VIEW, and REINDEX |