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 how there's much more
>>
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 other
considerations.
Yeah,
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 is that the OP's example wh
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 s
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 f
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
> pattern like that probably
[ 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
> something like adding rows wi