Re: disk filling up

From: Tom Lane
Subject: Re: disk filling up
Date: ,
Msg-id: 6791.1185859156@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Re: disk filling up  ("Merlin Moncure")
Responses: Re: disk filling up  ("Merlin Moncure")
List: pgsql-performance

Tree view

disk filling up  ("Brandon Shalton", )
 Re: disk filling up  (Bill Moran, )
 Re: disk filling up  (Mark Lewis, )
 Re: disk filling up  ("Joshua D. Drake", )
  Re: disk filling up  ("Merlin Moncure", )
   Re: disk filling up  (Tom Lane, )
    Re: disk filling up  ("Merlin Moncure", )
 Re: disk filling up  (Mark Kirkwood, )
  Re: disk filling up  (Yudhvir Singh Sidhu, )

"Merlin Moncure" <> writes:
> third (but unlikely) possibility is there are various dropped tables,
> etc which need to be deleted but there are stale postgresql processes
> holding on to the fd.  This would only happen following a postmaster
> crash or some other bizarre scenario, but i've seen it on production
> box.

Brent Reid reported something similar in bug #3483 but I'm still quite
unclear how it'd happen in any realistic scenario.  Can you create a
test case?

            regards, tom lane


pgsql-performance by date:

From: Henrik Zagerholm
Date:
Subject: Seq scan on join table despite index and high statistics
From: Andreas Tille
Date:
Subject: Using EXECUTE in a function