Postgres Pro
Downloads
Home   >   mailing lists

Re: Only owners can ANALYZE tables...seems overly restrictive - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Only owners can ANALYZE tables...seems overly restrictive
Date
Msg-id CAECtzeWD26iwpBafLs3UsJ25meXTgDGN3ujtbszBPO03sPD-ug@mail.gmail.com
Whole thread Raw
In response to Re: Only owners can ANALYZE tables...seems overly restrictive  (Vik Fearing <vik@2ndquadrant.fr>)
List pgsql-general
Tree view
2016-02-29 15:20 GMT+01:00 Vik Fearing <vik@2ndquadrant.fr>:
On 02/29/2016 03:15 PM, Guillaume Lelarge wrote:
> 2016-02-29 14:31 GMT+01:00 Stephen Frost <sfrost@snowman.net
> <mailto:sfrost@snowman.net>>:
>
>     Realistically, ANALYZE is a background/maintenance task that autovacuum
>     should be handling for you.
>
> Realistically, that can't happen every time. Think of temporary tables
> for example...

Hmm.  How are you not the owner of a temporary table?

Oh, you obviously are :)


--

pgsql-general by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Only owners can ANALYZE tables...seems overly restrictive
Next
From: "David G. Johnston"
Date:
Subject: Re: Only owners can ANALYZE tables...seems overly restrictive