| From: | Vik Fearing <vik(at)2ndquadrant(dot)fr> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | "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:20:57 |
| Message-ID: | 56D453C9.5050901@2ndquadrant.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2016-02-29 14:22:46 | Re: Only owners can ANALYZE tables...seems overly restrictive |
| Previous Message | Geoff Winkless | 2016-02-29 14:19:45 | Re: multicolumn index and setting effective_cache_size using human-readable-numbers |