Re: GIN pending list clean up exposure to SQL

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: GIN pending list clean up exposure to SQL
Дата
Msg-id CAHGQGwGcR_n4=q-NVWpzFpzx1GbJWwpjWCbtvwD0cHShvQNMmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GIN pending list clean up exposure to SQL  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
Список pgsql-hackers
On Sun, Nov 22, 2015 at 1:15 PM, Jaime Casanova
<jaime.casanova@2ndquadrant.com> wrote:
> On 21 November 2015 at 03:54, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
>> On 11/19/15 10:47 AM, Jaime Casanova wrote:
>>>
>>> - only superusers?
>>
>>
>> I would think the owner of the table (index?) should also be able to run
>> this.
>
> agreed, that makes sense

Also the function should ensure that the server is running in
normal mode (not recovery mode) and the specified relation is
NOT other session's temporary table.

I added the similar function into pg_bigm extension
(pg_gin_pending_cleanup function in
https://osdn.jp/projects/pgbigm/scm/git/pg_bigm/blobs/master/bigm_gin.c).
It might help us improve the patch.

Regards,

-- 
Fujii Masao



В списке pgsql-hackers по дате отправления: