Re: pg_stat_tmp files for dropped databases

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stat_tmp files for dropped databases
Date: 2014-03-05 16:05:12
Message-ID: 20140305160512.GL4759@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tomas Vondra wrote:
> On 22.2.2014 01:13, Thom Brown wrote:

> > I've noticed that files for dropped databases aren't removed from
> > pg_stat_tmp. After a cluster-wide VACUUM ANALYSE, and restarting
> > Postgres, all the old database pg_stat_tmp files remain.

> Yeah, that's a bug in pgstat_recv_dropdb() - instead of building path to
> the temporary file (in pg_stat_tmp), it builds a path to the permanent
> file in pg_stat.

Pushed, thanks.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-03-05 16:07:24 Re: jsonb and nested hstore
Previous Message Robert Haas 2014-03-05 15:55:59 Re: jsonb and nested hstore