On Tue, 31 Dec 2024 at 06:24, Ayush Vatsa wrote:
> To me, using a range of pages to prewarm a relation doesn’t seem like a
> common use case. For example, if a user calls prewarm(100, 200),
> how would they decide those specific numbers? While it’s possible to
> inspect the contents of those pages
On Mon, Dec 30, 2024 at 10:54:21PM +0530, Ayush Vatsa wrote:
> When I initially read the documentation, I found it unclear how someone
> would practically use the range feature. For instance, how would a user
> determine the specific range of pages they need in the buffer cache?
> Since PostgreSQL
> hmm, do we really need to highlight one specific usage for the range
> like this? I think mentioning this could just confuse readers as it
> makes it sound like using a range is going to magically run something
> in parallel.
I believe highlighting that particular use case would indeed be helpfu
On Sun, 29 Dec 2024 at 14:00, Bruce Momjian wrote:
> It feels like we should document what the block range is used for, so
> attached is a doc patch to do that.
- means prewarm through the last block in the relation). The return value
- is the number of blocks prewarmed.
+ means prewarm th
On Fri, Dec 13, 2024 at 05:20:05PM -0800, Jeremy Schneider wrote:
> On Fri, 13 Dec 2024 16:16:16 +0530
> Ayush Vatsa wrote:
>
> > How can I decide which range of pages to prewarm?
> > I assume that it is related to hot pages in the relation,
> > but how can I identify which pages are likely to be
On Fri, 13 Dec 2024 16:16:16 +0530
Ayush Vatsa wrote:
> How can I decide which range of pages to prewarm?
> I assume that it is related to hot pages in the relation,
> but how can I identify which pages are likely to be hot
> before they are even in the buffer cache?
> Additionally, since tuples
Hi PostgreSQL Community,
I have a question regarding the use of the pg_prewarm() function [1]
in the pg_prewarm extension. The function requires a relation name
and a range of pages (e.g., pages 10 to 50) to be warmed by shifting
them from disk to the buffer cache.
How can I decide which range of
