Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-09-03 Thread Pavel Stehule
hello 2010/8/31 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: there is a dump from 8KB files Well, those certainly look like tables/indexes not temp files. So we can rule out one theory. You're *certain* these aren't referenced from pg_class.relfilenode of any

Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-09-03 Thread Heikki Linnakangas
On 03/09/10 11:16, Pavel Stehule wrote: 2010/8/31 Tom Lanet...@sss.pgh.pa.us: Pavel Stehulepavel.steh...@gmail.com writes: there is a dump from 8KB files Well, those certainly look like tables/indexes not temp files. So we can rule out one theory. You're *certain* these aren't referenced

Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-09-03 Thread Pavel Stehule
2010/9/3 Heikki Linnakangas heikki.linnakan...@enterprisedb.com: On 03/09/10 11:16, Pavel Stehule wrote: 2010/8/31 Tom Lanet...@sss.pgh.pa.us: Pavel Stehulepavel.steh...@gmail.com  writes: there is a dump from 8KB files Well, those certainly look like tables/indexes not temp files. So we

Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-08-31 Thread Pavel Stehule
Subject Re: [HACKERS] thousand unrelated data files in pg_default tablespace Zdar, preposilam ti report 2010/8/30 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: I found a PostgreSQL 8.3 server (Linux) used for large OLAP where the data directory is bloating

Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-08-31 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: there is a dump from 8KB files Well, those certainly look like tables/indexes not temp files. So we can rule out one theory. You're *certain* these aren't referenced from pg_class.relfilenode of any of the databases in the server?

Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-08-30 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com writes: I found a PostgreSQL 8.3 server (Linux) used for large OLAP where the data directory is bloating. There are more than one hundred thousand files - 8KB or 0KB long. The filenames are not transformable to names via oid2name. Does somebody know about

Re: [HACKERS] thousand unrelated data files in pg_default tablespace

2010-08-30 Thread Pavel Stehule
2010/8/30 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com writes: I found a PostgreSQL 8.3 server (Linux) used for large OLAP where the data directory is bloating. There are more than one hundred thousand files - 8KB or 0KB long. The filenames are not transformable to names