| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Vik Fearing <vik(at)2ndquadrant(dot)fr> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Only owners can ANALYZE tables...seems overly restrictive |
| Date: | 2016-02-29 14:22:46 |
| Message-ID: | CAECtzeWD26iwpBafLs3UsJ25meXTgDGN3ujtbszBPO03sPD-ug@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2016-02-29 15:20 GMT+01:00 Vik Fearing <vik(at)2ndquadrant(dot)fr>:
> On 02/29/2016 03:15 PM, Guillaume Lelarge wrote:
> > 2016-02-29 14:31 GMT+01:00 Stephen Frost <sfrost(at)snowman(dot)net
> > <mailto:sfrost(at)snowman(dot)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 :)
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-02-29 14:52:42 | Re: Only owners can ANALYZE tables...seems overly restrictive |
| Previous Message | Vik Fearing | 2016-02-29 14:20:57 | Re: Only owners can ANALYZE tables...seems overly restrictive |