From: Justin Long <justinlong@strategicnetwork.org>
To: pgsql-sql@postgresql.org
Subject: Large objects - bug? caveat? feature?
Date: Fri, 23 Apr 1999 11:04:07 -0400
Message-ID: <000901be8d9a$88e2d680$0a411a9f@cbn.org> (raw)
I am using PHP3 with Apache on top of Linux, using beta 2 of PostgreSQL. I
have uncovered an interesting (bug/feature?) in the Large Objects.
If (using PHP3) you write out, say, a 2,000 byte large object (a text
article in this case), and then using an edit routine you replace that 2,000
object with a more concise, edited 1,000-byte document, what you get is the
1,000-bytes of the edit, followed by the final 1,000 bytes of the original
2,000 byte article. In other words, it doesn't shrink the file to the edited
size.
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? Does Linux suffer
degradation in performance when having that many files in a directory?
Justin
Never retreat. Never surrender. Never cut a deal with a dragon.
_______________________________________________________________
Justin Long CIO / Site Editor
616 Station Square Ct Network for Strategic Missions
Chesapeake, VA 23320 977 Centerville Trnpk CSB 317
JustinLong@xc.org Va Beach, VA 23463
Check out our site at: http://www.strategicnetwork.org
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: justinlong@strategicnetwork.org
Subject: Re: Large objects - bug? caveat? feature?
In-Reply-To: <000901be8d9a$88e2d680$0a411a9f@cbn.org>
References: <000901be8d9a$88e2d680$0a411a9f@cbn.org>
* 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