From: | Don Seiler <don(at)seiler(dot)us> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Adrien Nayrat <adrien(dot)nayrat(at)dalibo(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: No stats after promoting standby? |
Date: | 2017-12-04 22:49:31 |
Message-ID: | CAHJZqBDNi261RxxmCXmW_YojnkSOcBshVnJoiUL1mNc3j_o5PA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Dec 4, 2017 at 4:36 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
wrote:
> The optimizer stats are not lost on crash or promote actually; these are
> stored in pg_statistic (not in the stats collector) and *are* part of
> regular "data".
>
> ...
>
> I think it's pretty common misunderstanding -- it's not easy to see the
> boundary between pg_statistic and pg_stat_* tables.
Thanks for this. I thought I remembered being corrected on this before
(probably on this very list) and just came to think of it at the end of my
last message.
So what, exactly ARE the pg_stat_* tables? Is that the data stored in the
files in stats_temp_directory? How do they differ from pg_statistic?
I've found this blog post that seems to answer that question with a "Yes":
https://blog.pgaddict.com/posts/the-two-kinds-of-stats-in-postgresql
--
Don Seiler
www.seiler.us
From | Date | Subject | |
---|---|---|---|
Next Message | 2017-12-05 14:30:23 | Docker Image | |
Previous Message | Alvaro Herrera | 2017-12-04 22:36:47 | Re: No stats after promoting standby? |