2010/9/3 Heikki Linnakangas :
> On 03/09/10 11:16, Pavel Stehule wrote:
>>
>> 2010/8/31 Tom Lane:
>>>
>>> Pavel Stehule 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
On 03/09/10 11:16, Pavel Stehule wrote:
2010/8/31 Tom Lane:
Pavel Stehule 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 dat
hello
2010/8/31 Tom Lane :
> Pavel Stehule 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?
Pavel Stehule 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?
regards, tom lan
$ ls -l /srv/postgresql/data/base/3400014/27059918
> -rw--- 1 postgres postgres 8192 Jul 1 06:28
> /srv/postgresql/data/base/3400014/27059918
>
>
>
> Pavel Stehule
>
> 31.08.2010 09:32
>
> To
> robert.mou...@lmc.eu
> cc
> Subject
> Re: [HACKERS] thousand unrel
2010/8/30 Tom Lane :
> Pavel Stehule 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
Pavel Stehule 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 similar bug?
1. 8.3
Hello
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 similar bug?
Regards
Pavel Stehule
--
Se
