Re: [BUGS] Routine analyze of single column prevents standard autoanalyze from running at all
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jim Nasby <Jim.Nasby@BlueTreble.com>
Cc: Josh berkus <josh@agliodbs.com>,
Tomasz Ostrowski <tometzky+pg@ato.waw.pl>,
pgsql-hackers@postgresql.org
Date: 2016-06-08T03:04:05Z
Lists: pgsql-bugs, pgsql-hackers
Jim Nasby <Jim.Nasby@BlueTreble.com> 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 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 how there's much more expense in analyzing them all. regards, tom lane