From: Chris Bitmead <chris.bitmead@bigfoot.com>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Large objects - bug? caveat? feature?
Date: Sat, 24 Apr 1999 02:58:53 +0000
Message-ID: <3721336D.10BB8F3C@bigfoot.com> (raw)
References: <000901be8d9a$88e2d680$0a411a9f@cbn.org>
Justin Long wrote:
> 2,000 byte article. In other words, it doesn't shrink the file > to the edited size.
Does the interface have any equivilent to the UNIX O_TRUNC?
> Secondly, I notice that in my data/base/... area that whenever I create an
> object it creates a single file on the disk. Does that mean that if I have
> 100,000 articles in my knowledge base, that it is possible that I will have
> 100,000 files individual 8-to-10k files on my hard drive?
It's worse than that I think. I believe you get _two_ files for each
large object. Large objects really suck badly.
> Does Linux suffer
> degradation in performance when having that many files in a
> directory?
Absolutely does suffer. Even worse, your regular database tables are in
the same directory, so they'll suffer too. Another problem, is pgdump
doesn't dump large objects so you have to figure out some other backup
strategy.
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: chris.bitmead@bigfoot.com
Subject: Re: [SQL] Large objects - bug? caveat? feature?
In-Reply-To: <3721336D.10BB8F3C@bigfoot.com>
References: <000901be8d9a$88e2d680$0a411a9f@cbn.org> <3721336D.10BB8F3C@bigfoot.com>
* 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