Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

Tomasz Ostrowski writes: > W dniu 2016-06-08 o 05:04, Tom Lane pisze: >> Yeah, my guess is that the OP's example where analyzing just one column >> was significantly cheaper boiled down to some of the other columns being >> mostly toasted data. Otherwise it's hard to see

Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

W dniu 2016-06-08 o 05:04, Tom Lane pisze: Jim Nasby writes: Is there any significant advantage to not analyzing all columns? Only case I can think of is if you have a fair number of columns that have been toasted; otherwise I'd think IO would completely swamp any

Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

Jim Nasby writes: > Is there any significant advantage to not analyzing all columns? Only > case I can think of is if you have a fair number of columns that have > been toasted; otherwise I'd think IO would completely swamp any other > considerations. Yeah, my guess

Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

On 6/6/16 3:23 PM, Josh berkus wrote: On 06/06/2016 01:38 PM, Tom Lane wrote: Also, I'd be a bit inclined to disable the counter reset whenever a column list is specified, disregarding the corner case where a list is given but it includes all the table's analyzable columns. It doesn't really

Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

On 06/06/2016 01:38 PM, Tom Lane wrote: > Also, I'd be a bit inclined to disable the counter reset whenever a column > list is specified, disregarding the corner case where a list is given but > it includes all the table's analyzable columns. It doesn't really seem > worth the effort to account

Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

I wrote: > Tomasz Ostrowski writes: >> I suppose this is a bug - an analyze, which does not analyze all >> columns, should not reset pg_stat_user_tables(n_mod_since_analyze). What >> do you think? > I'm inclined to think that this is a reasonable complaint. A usage >

Re: [HACKERS] [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all

[ redirecting to -hackers ] Tomasz Ostrowski writes: > I'm routinely bulk inserting data to a PostgreSQL table and then > analyzing a single column of the table, because it contains data which > significantly changes histogram of this column values - for example >