Re: Extension Enhancement: Buffer Invalidation in pg_buffercache

2023-07-31 Thread Palak Chaturvedi
Hii, Thanks for your feedback. We have decided to add a role for the extension to solve that problem. And concerning to pg_unwarm table I think we can create a new function to do that but I think a general user would not require to clear a table from buffercache. We can use bufferid and where

Re: Extension Enhancement: Buffer Invalidation in pg_buffercache

2023-07-11 Thread Palak Chaturvedi
Can you please review the new patch of the extension with implemented force variable. On Tue, 11 Jul 2023 at 18:08, Palak Chaturvedi wrote: > > Hey Nitin, > >Will > >there be a scenario where the buffer is dirty and its reference count > >is zero? > There might be a b

Re: Extension Enhancement: Buffer Invalidation in pg_buffercache

2023-07-11 Thread Palak Chaturvedi
+*/ > > +bool > > The star(*) and space are missing here. Please refer to the style of > function comments and change accordingly. > > Thanks & Regards, > Nitin Jadhav > > On Fri, Jun 30, 2023 at 4:17 PM Palak Chaturvedi > wrote: > > > > I hope this email

Re: Extension Enhancement: Buffer Invalidation in pg_buffercache

2023-07-04 Thread Palak Chaturvedi
Palak Chaturvedi > wrote: > > > > Hi Thomas, > > Thank you for your suggestions. I have added the sql in the meson > > build as well. > > > > On Sat, 1 Jul 2023 at 03:39, Thomas Munro wrote: > > > > > > On Fri, Jun 30, 2023 at 10:47 P

Re: Extension Enhancement: Buffer Invalidation in pg_buffercache

2023-07-03 Thread Palak Chaturvedi
Hi Thomas, Thank you for your suggestions. I have added the sql in the meson build as well. On Sat, 1 Jul 2023 at 03:39, Thomas Munro wrote: > > On Fri, Jun 30, 2023 at 10:47 PM Palak Chaturvedi > wrote: > > pgbench=# select count(pg_buffercache_invalidate(bufferid)) from >

Extension Enhancement: Buffer Invalidation in pg_buffercache

2023-06-30 Thread Palak Chaturvedi
I hope this email finds you well. I am excited to share that I have extended the functionality of the `pg_buffercache` extension by implementing buffer invalidation capability, as requested by some PostgreSQL contributors for improved testing scenarios. This marks my first time submitting a patch