From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PostgreSQL 9.2.4 temp files never released? |
Date: | 2013-09-28 21:26:58 |
Message-ID: | BLU0-SMTP1548633B5FA08AC40C83E1DCF2A0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Em 28/09/2013 18:23, Jeff Janes escreveu:
> On Sat, Sep 28, 2013 at 1:54 PM, Edson Richter
> <edsonrichter(at)hotmail(dot)com <mailto:edsonrichter(at)hotmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2013-09-28 22:43:56 | Re: recovery from incomplete backup (pgsql 8.3) |
Previous Message | Edson Richter | 2013-09-28 21:25:43 | Re: PostgreSQL 9.2.4 temp files never released? |