consecutive analyze calls with different column lists.

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: consecutive analyze calls with different column lists.
Date: 2011-12-19 13:04:32
Message-ID: C4DAC901169B624F933534A26ED7DF310861B24C@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

If I call analyze 2 times, e.g.

analyze mytable (column_a, column_b);
analyze mytable (column_a, column_c);

then I will loose statisics on column_b.

correct ?

many thanks,

Marc Mamin

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-12-19 14:19:21 Re: ignore duplicate key while using COPY?
Previous Message Merlin Moncure 2011-12-19 13:02:19 Re: Logical Aggregate Functions (eg ANY())