pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Joyce <tim@hoop.co.uk>
To: pgsql-interfaces@postgreSQL.org
To: stuart@comodo.net
To: Gene Selkov, Jr. <selkovjr@mcs.anl.gov>
Subject: Re: [INTERFACES] 8k limit
Date: Wed, 27 Oct 1999 07:29:58 +0100
Message-ID: <005201bf2046$159bb9f0$0501a8c0@noonoo> (raw)
References: <199910270541.AAA25460@antares>

>
> 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

cheers

timj







view thread (6+ messages)  latest in thread

Message-ID: <005201bf2046$159bb9f0$0501a8c0@noonoo>
Permalink:  ../005201bf2046$159bb9f0$0501a8c0@noonoo/
Also on:    postgresql.org/message-id/005201bf2046$159bb9f0$0501a8c0@noonoo

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: tim@hoop.co.uk, stuart@comodo.net, selkovjr@mcs.anl.gov
  Subject: Re: [INTERFACES] 8k limit
  In-Reply-To: <005201bf2046$159bb9f0$0501a8c0@noonoo>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox