Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] 8k limit

From: "Tim Joyce" <tim(at)hoop(dot)co(dot)uk>
To: <pgsql-interfaces(at)postgreSQL(dot)org>, <stuart(at)comodo(dot)net>, "Gene Selkov, Jr(dot)" <selkovjr(at)mcs(dot)anl(dot)gov>
Subject: Re: [INTERFACES] 8k limit
Date: 1999-10-27 06:29:58
Message-ID: 005201bf2046$159bb9f0$0501a8c0@noonoo (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
> For example, my file system can have 1064960 files in it (one can find
> that out with fsck), but the practical constraint will be much
> lower. I find it difficult to deal with 30000 files in one directory,
> for example. The time it takes to open a file in such directory is
> usually on the order of seconds.

I don't know if this info is useful, but;

I have a directory with 150K files in it, and can open files in it without
noticable delay (this is not through postgres).  Before setting up this dir,
i tried to find out the limit of how many files is sensible.  I couldn't
find any info so just thought i'd try it, and it appears to work fine.  If
you think I am going to hit problems (I am serving jpgs from this directory
for a web site), please let me know.

running on
Red Hat Linux release 5.2 (Apollo)
Kernel 2.0.36 on an i686



In response to

pgsql-interfaces by date

Next:From: martenDate: 1999-10-27 06:41:02
Subject: Re: [INTERFACES] 8k limit
Previous:From: Gene Selkov, Jr.Date: 1999-10-27 04:40:58
Subject: Re: [INTERFACES] 8k limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group