Skip site navigation (1) Skip section navigation (2)

Re: Stats turned on but not being updated

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: adey11(at)gmail(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Stats turned on but not being updated
Date: 2005-09-09 02:52:37
Message-ID: 28966.1126234357@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
adey <adey11(at)gmail(dot)com> writes:
>  However, since that first test query yesterday (and I've run several since=
> =20
> on different tables today - some of them repeated to ensure the buffer=20
> should be populated), the statistics haven't changed.

That seems pretty odd.  Look in the postmaster log to see if you can
find any relevant error messages.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Mauri SahlbergDate: 2005-09-09 13:20:21
Subject: Stupid question about triggers
Previous:From: adeyDate: 2005-09-09 01:13:32
Subject: Stats turned on but not being updated

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group