Re: PostgreSQL 9.2.4 temp files never released?

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Re: PostgreSQL 9.2.4 temp files never released?
Дата
Msg-id BLU0-SMTP1548633B5FA08AC40C83E1DCF2A0@phx.gbl
обсуждение исходный текст
Ответ на Re: PostgreSQL 9.2.4 temp files never released?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Em 28/09/2013 18:23, Jeff Janes escreveu:
On Sat, Sep 28, 2013 at 1:54 PM, Edson Richter <edsonrichter@hotmail.com> wrote:
Em 28/09/2013 15:54, Adrian Klaver escreveu:

Ok. Found the place.
So, there is nothing there. PG_DATA/base/pgsql_tmp is a empty directory.
I've run the query over pg_stat_database view and there is nothing wrong with pgAdmin III - the information is all there.
I've also run a vacuum freeze analyze, but made no difference.

I believe that statistics are outdated, since there is no temp file at all.

The statistics are not current, they are cumulative since the database was created, or pg_stat_reset() was last called.
 
Cheers,

Jeff
Thanks, Jeff!
I now understand.

Regards,

Edson

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

Предыдущее
От: Edson Richter
Дата:
Сообщение: Re: PostgreSQL 9.2.4 temp files never released?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: recovery from incomplete backup (pgsql 8.3)