What is your pg_stat_tmp directory ? Just a random guess, any chances that
someone played with pgstat.stat file ?
Thanks,
Adarsh Sharma
On Mon, Jul 25, 2016 at 8:51 PM, Sameer Kumar
wrote:
>
>
> On Mon, 25 Jul 2016, 10:35 p.m. Adrian Klaver,
> wrote:
>
>> On 07/25/2016 07:28 AM, Sameer Kumar w
On 07/25/2016 08:21 AM, Sameer Kumar wrote:
Don't suppose you still have the logs from that date to see if there is
a clue?
I don't have them on the server. I can fetch them from the archives. Ot
might tke a day or two. Let me get back. Thanks for helping.
Any idea about probable
On Mon, 25 Jul 2016, 10:35 p.m. Adrian Klaver,
wrote:
> On 07/25/2016 07:28 AM, Sameer Kumar wrote:
> >
> >
> > On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver,
> > mailto:adrian.kla...@aklaver.com>> wrote:
> >
> > On 07/24/2016 09:58 PM, Sameer Kumar wrote:
> > > Hi,
> > >
> > > I
On 07/25/2016 07:28 AM, Sameer Kumar wrote:
On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver,
mailto:adrian.kla...@aklaver.com>> wrote:
On 07/24/2016 09:58 PM, Sameer Kumar wrote:
> Hi,
>
> I have PostgreSQL v9.4.4 running in my environment. It has been up for
> over 2 years n
On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver,
wrote:
> On 07/24/2016 09:58 PM, Sameer Kumar wrote:
> > Hi,
> >
> > I have PostgreSQL v9.4.4 running in my environment. It has been up for
> > over 2 years now. I noticed that suddenly the statistics have been reset
> > and all the stat tables/colum
On 07/24/2016 09:58 PM, Sameer Kumar wrote:
Hi,
I have PostgreSQL v9.4.4 running in my environment. It has been up for
over 2 years now. I noticed that suddenly the statistics have been reset
and all the stat tables/columns got restarted from.
Any of these happen?:
https://www.postgresql.org/
Hi,
I have PostgreSQL v9.4.4 running in my environment. It has been up for over
2 years now. I noticed that suddenly the statistics have been reset and all
the stat tables/columns got restarted from.
This happened 2 weeks ago. I noticed only recently after I looked at the
plot over last week (whi
