Re: [GENERAL] Possibly stupid questions re: large tables/files, port 5432 access

2004-10-14 Thread Alvaro Herrera
On Thu, Oct 14, 2004 at 02:00:51PM -0700, Michael Holden wrote: > There is a file located at > > /usr/local/pgsql/data/base/26920/ > > named 35987 that is roughly 750mb. Is there any way to find out what > table or database this file belongs to? Sure, use contrib/oid2name. > I really shouldn

[GENERAL] Possibly stupid questions re: large tables/files, port 5432 access

2004-10-14 Thread Michael Holden
Hi, folks There is a file located at /usr/local/pgsql/data/base/26920/ named 35987 that is roughly 750mb. Is there any way to find out what table or database this file belongs to? I really shouldn't have that much data in any of my tables, so I'm fairly certain that this is a bug in my code