Re: Must be owner to truncate?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Must be owner to truncate?
Дата
Msg-id 20050708130653.GO24207@ns.snowman.net
обсуждение исходный текст
Ответ на Re: Must be owner to truncate?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
* Christopher Kings-Lynne (chriskl@familyhealth.com.au) wrote:
> I'm strongly in favour of this patch.  I am currently in this situation:
>
> 1. Web db user runs as non-superuser, non-owner.
> 2. I have a table of a tens of thousands of rows that I must delete
> entirely and rebuild every day at least (pg_trgm word list)
> 3. It just gets slow over time, even with autovac.
> 4. I can't vacuum it as i'm not the owner, and I cannot truncate it either.
> 5. Table has no triggers or FK's whatsoever.
>
> So, stephen frost's suggestion would be fantastic.

This is a very similar situation to what I'm in, which is why I was
asking for the change. :)
Thanks,
    Stephen

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

Предыдущее
От: Dawid Kuroczko
Дата:
Сообщение: Re: Checkpoint cost, looks like it is WAL/CRC
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Must be owner to truncate?