Re: [ADMIN] Stats Disappear After Minor Upgrade?

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: [ADMIN] Stats Disappear After Minor Upgrade?
Дата
Msg-id CAHJZqBB-eH_pYQ-fVUi=cGGxqFngL_qw9jduoVJYWvLdMM4mVw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Stats Disappear After Minor Upgrade?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
On Tue, Aug 15, 2017 at 5:50 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

How did you shut down the existing installation?  This'd be expected if
you used "--mode immediate".  Otherwise, I'd have thought those stats
would still be there.

pg_ctl stop -m fast

That's how I've been doing it this whole while. My connotation is that postgres "fast" shutdown equates to oracle's immediate shutdown, but postgres "immediate" shutdown is akin to oracle's "shutdown abort". So fast should be a safe, consistent shutdown that doesn't require crash recovery after.

The optimizer's decisions are generally not based on the stats collector's
info, but on the contents of pg_statistic.  This observation doesn't prove
anything about whether that was intact ... but I'd be really surprised
if it wasn't.

Interesting, I'll have to read up on the difference here. I'm going to see if I can get another clone made up and test again, being sure to get the info before and after. 


--
Don Seiler
www.seiler.us

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] Stats Disappear After Minor Upgrade?
Следующее
От: bhawana mishra
Дата:
Сообщение: [ADMIN] Issues while installing PostgreSQL 9.6 on SUSE linux from repository