| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Joel Jacobson <joel(at)compiler(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: [PATCH] pg_permissions |
| Date: | 2021-03-26 10:30:37 |
| Message-ID: | 20210326103037.GA5136@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2021-Mar-26, Joel Jacobson wrote:
> On Thu, Mar 25, 2021, at 17:51, Tom Lane wrote:
> > I wonder what performance will be like with lots o' objects.
>
> I guess pg_get_acl() would need to be implemented using a switch(classid) with 36 cases (one for each class)?
No, we have a generalized object query mechanism, see objectaddress.c
> Is your performance concern on how such switch statement will be optimized by the C-compiler?
I guess he is concerned about the number of catalog accesses.
--
Álvaro Herrera 39°49'30"S 73°17'W
"Saca el libro que tu religión considere como el indicado para encontrar la
oración que traiga paz a tu alma. Luego rebootea el computador
y ve si funciona" (Carlos Duclós)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2021-03-26 11:37:37 | Re: PoC/WIP: Extended statistics on expressions |
| Previous Message | Amit Kapila | 2021-03-26 10:19:27 | Re: [PATCH] add concurrent_abort callback for output plugin |