Re: Must be owner to truncate? - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Must be owner to truncate?
Date
Msg-id 20050708130653.GO24207@ns.snowman.net
Whole thread Raw
In response to Re: Must be owner to truncate?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: Checkpoint cost, looks like it is WAL/CRC
Next
From: Stephen Frost
Date:
Subject: Re: Must be owner to truncate?