Jim Nasby <jim.na...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
