Home > mailing lists

consecutive analyze calls with different column lists. - Mailing list pgsql-general

From	Marc Mamin
Subject	consecutive analyze calls with different column lists.
Date	December 19, 2011 09:05:00
Msg-id	C4DAC901169B624F933534A26ED7DF310861B24C@JENMAIL01.ad.intershop.net Whole thread Raw
List	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

From: Merlin Moncure
Date: 19 December 2011, 09:02:37
Subject: Re: Logical Aggregate Functions (eg ANY())

From: Adrian Klaver
Date: 19 December 2011, 10:19:46
Subject: Re: ignore duplicate key while using COPY?