From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
---|---|
To: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
Cc: | Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Melanie Plageman <melanieplageman(at)gmail(dot)com> |
Subject: | Re: Streaming I/O, vectored I/O (WIP) |
Date: | 2024-04-03 00:31:11 |
Message-ID: | CA+hUKGLLFvou5rx5FDhm-Pc9r4STQTFFmrx6SUV+vk8fwMbreA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Apr 2, 2024 at 9:39 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> So this is the version I'm going to commit shortly, barring objections.
And done, after fixing a small snafu with smgr-only reads coming from
CreateAndCopyRelationData() (BM_PERMANENT would be
incorrectly/unnecessarily set for unlogged tables).
Here are the remaining patches discussed in this thread. They give
tablespace-specific io_combine_limit, effective_io_readahead_window
(is this useful?), and up-to-1MB io_combine_limit (is this useful?).
I think the first two would probably require teaching reloption.c how
to use guc.c's parse_int() and unit flags, but I won't have time to
look at that for this release so I'll just leave these here.
On the subject of guc.c, this is a terrible error message... did I do
something wrong?
postgres=# set io_combine_limit = '42MB';
ERROR: 5376 8kB is outside the valid range for parameter
"io_combine_limit" (1 .. 32)
Attachment | Content-Type | Size |
---|---|---|
v16-0001-ALTER-TABLESPACE-.-SET-io_combine_limit.patch | text/x-patch | 11.3 KB |
v16-0002-Add-effective_io_readahead_window-setting.patch | text/x-patch | 13.6 KB |
v16-0003-Increase-PG_IOV_MAX-for-bigger-io_combine_limit.patch | text/x-patch | 2.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Fan | 2024-04-03 01:33:28 | Re: using extended statistics to improve join estimates |
Previous Message | Thomas Munro | 2024-04-03 00:00:01 | Re: Building with musl in CI and the build farm |