Re: Allow to specify a index name as ANALYZE parameter

2018-10-01 Thread Michael Paquier
On Sun, Sep 09, 2018 at 01:25:49PM +0700, John Naylor wrote: > I'm interested in this feature, so I've signed up to help review. > Given the above, I thought it appropriate to mark the patch Waiting on > Author. I find this feature interesting as well. The patch has been waiting on author input

Re: Allow to specify a index name as ANALYZE parameter

2018-09-09 Thread John Naylor
On 7/12/18, Yugo Nagata wrote: > On Wed, 11 Jul 2018 14:26:03 +0300 > Alexander Korotkov wrote: >> However, since multicolumn index may contain multiple expression, I >> think we should support specifying columns for ANALYZE index clause. >> We could support specifying columns by their numbers

Re: Allow to specify a index name as ANALYZE parameter

2018-07-15 Thread Vik Fearing
On 11/07/18 11:04, Yugo Nagata wrote: > A usecase I suppose is that when a new expression index is created and that > we need only the statistics for the new index. I wonder if this shouldn't just be done automatically. -- Vik Fearing +33 6 46 75 15 36

Re: Allow to specify a index name as ANALYZE parameter

2018-07-11 Thread Yugo Nagata
On Wed, 11 Jul 2018 14:26:03 +0300 Alexander Korotkov wrote: > On Wed, Jul 11, 2018 at 12:04 PM Yugo Nagata wrote: > > When we specify column names for ANALYZE, only the statistics for those > > columns > > are collected. Similarly, is it useful if we have a option to specify an > > index >

Re: Allow to specify a index name as ANALYZE parameter

2018-07-11 Thread Alexander Korotkov
Hi! On Wed, Jul 11, 2018 at 12:04 PM Yugo Nagata wrote: > When we specify column names for ANALYZE, only the statistics for those > columns > are collected. Similarly, is it useful if we have a option to specify an index > for ANALYZE to collect only the statistics for expression in the

Allow to specify a index name as ANALYZE parameter

2018-07-11 Thread Yugo Nagata
Hi, When we specify column names for ANALYZE, only the statistics for those columns are collected. Similarly, is it useful if we have a option to specify an index for ANALYZE to collect only the statistics for expression in the specified index? A usecase I suppose is that when a new expression