Postgres Pro
Downloads
Home   >   mailing lists

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

From Vik Fearing
Subject Re: Only owners can ANALYZE tables...seems overly restrictive
Date
Msg-id 56D453C9.5050901@2ndquadrant.fr
Whole thread Raw
In response to Re: Only owners can ANALYZE tables...seems overly restrictive  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: Only owners can ANALYZE tables...seems overly restrictive  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Only owners can ANALYZE tables...seems overly restrictive  (Bosco Rama <postgres@boscorama.com>)
List pgsql-general
Tree view 
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?
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: multicolumn index and setting effective_cache_size using human-readable-numbers
Next
From: Guillaume Lelarge
Date:
Subject: Re: Only owners can ANALYZE tables...seems overly restrictive