Re: postgres load at restore

On Fri, 30 Aug 2024 at 19:17, Phil Stracchino <[email protected]> wrote:
> I tried running a restore of my workstation this morning, and it still
> took more than four minutes to build the directory tree.
>
>
> Does this seem as though the bvfs cache is being built correctly and
> used?  Is there a way I can test and verify that it is working correctly?

Hello Phil,

I don't know any dedicated tool to check Bvfs cache but there can be
used the .bvfs_* bconsole commands for that. It can be .bvfs_lsdirs
like below:

If cache for jobid 42328 is not created, the .bvfs_lsdirs lists only this:

# Check if cache exists for a jobid
.bvfs_lsdirs jobid=42328 path=
84773 0 0 0 A A A A A A A A A A A A A A .

Once the cache is created, we are able to go through the Bvfs
directory structure:

# Update Bvfs cache
.bvfs_update jobid=42328

# Check if cache exists for a jobid
.bvfs_lsdirs jobid=42328 path=
84773 0 0 0 A A A A A A A A A A A A A A .
84772 0 0 0 A A A A A A A A A A A A A A /
.bvfs_lsdirs jobid=42328 path=/
84772 0 0 0 A A A A A A A A A A A A A A .
84773 0 0 0 A A A A A A A A A A A A A A ..
86863 0 0 0 A A A A A A A A A A A A A A home/
.bvfs_lsdirs jobid=42328 path=/home/
86863 0 0 0 A A A A A A A A A A A A A A .
84772 0 0 0 A A A A A A A A A A A A A A ..
86862 0 0 0 A A A A A A A A A A A A A A gani/

Best regards,
Marcin Haba (gani)