Re: PATCH: Attempt to make dbsize a bit more consistent

2021-04-08 Thread Michael Paquier
On Wed, Mar 17, 2021 at 02:35:28PM +0900, Michael Paquier wrote: > So we would likely want a separate function. Another possibility, > which I find tempting, would be to push down the calculation logic > relying on physical files down to the table AM themselves with a new > dedicated callback (rel

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-03-23 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Wednesday, March 17, 2021 6:35 AM, Michael Paquier wrote: > On Mon, Mar 15, 2021 at 03:10:59PM +0900, Michael Paquier wrote: > > > Anyway, as mentioned by other people upthread, I am not really > > convinced either that we should have more flavors of siz

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-03-16 Thread Michael Paquier
On Mon, Mar 15, 2021 at 03:10:59PM +0900, Michael Paquier wrote: > Anyway, as mentioned by other people upthread, I am not really > convinced either that we should have more flavors of size functions, > particularly depending on the relkind as this would be confusing for > the end-user. pg_relatio

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-03-15 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Monday, March 15, 2021 7:10 AM, Michael Paquier wrote: > On Wed, Feb 24, 2021 at 02:35:51PM +, gkokola...@pm.me wrote: > > > Now with attachment. Apologies for the chatter. > > The patch has no documentation for the two new functions, so it is a > bit

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-03-14 Thread Michael Paquier
On Wed, Feb 24, 2021 at 02:35:51PM +, gkokola...@pm.me wrote: > Now with attachment. Apologies for the chatter. The patch has no documentation for the two new functions, so it is a bit hard to understand what is the value brought here, and what is the goal wanted just by reading the patch, exc

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-02-24 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Wednesday, February 24, 2021 3:34 PM, wrote: > > > ‐‐‐ Original Message ‐‐‐ > On Friday, February 19, 2021 4:57 PM, gkokola...@pm.me wrote: > > > ‐‐‐ Original Message ‐‐‐ > > On Monday, February 1, 2021 1:18 PM, Masahiko Sawada sawada.m...@

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-02-24 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Friday, February 19, 2021 4:57 PM, wrote: > > > ‐‐‐ Original Message ‐‐‐ > On Monday, February 1, 2021 1:18 PM, Masahiko Sawada sawada.m...@gmail.com > wrote: > > > On Thu, Nov 12, 2020 at 2:54 AM Soumyadeep Chakraborty > > soumyadeep2...@gmail.c

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-02-19 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Monday, February 1, 2021 1:18 PM, Masahiko Sawada wrote: > On Thu, Nov 12, 2020 at 2:54 AM Soumyadeep Chakraborty > soumyadeep2...@gmail.com wrote: > > > Hey Georgios, > > On Tue, Nov 10, 2020 at 6:20 AM gkokola...@pm.me wrote: > > > > > ‐‐‐ Original

Re: PATCH: Attempt to make dbsize a bit more consistent

2021-02-01 Thread Masahiko Sawada
On Thu, Nov 12, 2020 at 2:54 AM Soumyadeep Chakraborty wrote: > > Hey Georgios, > > On Tue, Nov 10, 2020 at 6:20 AM wrote: > > > > > > > > > > > > > > ‐‐‐ Original Message ‐‐‐ > > On Monday, November 9, 2020 7:50 PM, Soumyadeep Chakraborty > > wrote: > > > > > Hey Georgios, > > > > > >

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-11-11 Thread Soumyadeep Chakraborty
Hey Georgios, On Tue, Nov 10, 2020 at 6:20 AM wrote: > > > > > > > ‐‐‐ Original Message ‐‐‐ > On Monday, November 9, 2020 7:50 PM, Soumyadeep Chakraborty > wrote: > > > Hey Georgios, > > > > Thanks for looking for more avenues to invoke tableAM APIS! Please find > > my review below: > >

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-11-10 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Monday, November 9, 2020 7:50 PM, Soumyadeep Chakraborty wrote: > Hey Georgios, > > Thanks for looking for more avenues to invoke tableAM APIS! Please find > my review below: A great review Soumyadeep, it is much appreciated. Please remember to add your

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-11-09 Thread Soumyadeep Chakraborty
Hey Georgios, Thanks for looking for more avenues to invoke tableAM APIS! Please find my review below: On Tue, Oct 13, 2020 at 6:28 AM wrote: 1. > /* > - * heap size, including FSM and VM > + * table size, including FSM and VM > */ We should not mention FSM and VM in dbsize.c at all as thes

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-10-13 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Thursday, September 10, 2020 12:51 PM, Daniel Gustafsson wrote: [snip] > Since we have introduced the table AM api I support going throug it for all > table accesses, so +1 on the overall idea. > Thank you for reviewing! Please find v2 of the patch atta

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-23 Thread Michael Paquier
On Thu, Sep 10, 2020 at 11:51:30AM +0200, Daniel Gustafsson wrote: > Some comments on the patch: Extra comment for this patch: regression tests are failing. -- Michael signature.asc Description: PGP signature

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-10 Thread Daniel Gustafsson
>> So what do you think of the patch? > > I would suggest to keep the original logic unless there is a bug. IIUC, the premise of this path submission is that this codepath is in fact buggy as it may lead to incorrect results for non-heap relations? Since we have introduced the table AM api I sup

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-09 Thread David Zhang
On 2020-09-09 12:41 a.m., gkokola...@pm.me wrote: ‐‐‐ Original Message ‐‐‐ On Tuesday, 8 September 2020 22:26, David Zhang wrote: I found the function "table_relation_size" is only used by buffer manager for "RELKIND_RELATION", "RELKIND_TOASTVALUE" and "RELKIND_MATVIEW", i.e.    

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-09 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Tuesday, 8 September 2020 22:26, David Zhang wrote: > > > I found the function "table_relation_size" is only used by buffer > manager for "RELKIND_RELATION", "RELKIND_TOASTVALUE" and > "RELKIND_MATVIEW", i.e. > >         case RELKIND_RELATION: >         c

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-09 Thread gkokolatos
‐‐‐ Original Message ‐‐‐ On Tuesday, 8 September 2020 16:49, John Naylor wrote: > On Thu, Aug 27, 2020 at 9:39 AM gkokola...@pm.me wrote: > > > Hi all, > > this minor patch is attempting to force the use of the tableam api in > > dbsize where ever it is required. > > Apparently so

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-08 Thread David Zhang
I found the function "table_relation_size" is only used by buffer manager for "RELKIND_RELATION", "RELKIND_TOASTVALUE" and "RELKIND_MATVIEW", i.e.         case RELKIND_RELATION:         case RELKIND_TOASTVALUE:         case RELKIND_MATVIEW:             {                 /*                  *

Re: PATCH: Attempt to make dbsize a bit more consistent

2020-09-08 Thread John Naylor
On Thu, Aug 27, 2020 at 9:39 AM wrote: > > Hi all, > > this minor patch is attempting to force the use of the tableam api in dbsize > where ever it is required. > > Apparently something similar was introduced for toast relations only. > Intuitively it seems that the distinction between a table a

PATCH: Attempt to make dbsize a bit more consistent

2020-08-27 Thread gkokolatos
Hi all, this minor patch is attempting to force the use of the tableam api in dbsize where ever it is required. Apparently something similar was introduced for toast relations only. Intuitively it seems that the distinction between a table and a toast table is not needed. This patch treats tab