Re: Stats not getting updated.... - Mailing list pgsql-general

From Richard Huxton
Subject Re: Stats not getting updated....
Date
Msg-id 429EE70C.1010408@archonet.com
Whole thread Raw
In response to Re: Stats not getting updated....  (Himanshu Baweja <himanshubaweja@yahoo.com>)
Responses Re: Stats not getting updated....
List pgsql-general
Himanshu Baweja wrote:
> i also noted one more thing... the stats are getting updated only
> when i do vacuum.... is that wht is supposed to happen... or
> something is wrong....

Hmm - there's something strange going on certainly. Try a couple of
simple queries on a table and see whether the stats get updated.

It is possible that during very busy periods the stats don't get
recorded - that's part of the design.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [SQL] index row size 2728 exceeds btree maximum, 2713
Next
From: Shaun Clements
Date:
Subject: Automate Postgres Backup In windows