Patch for better large objects support

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Patch for better large objects support
Date: 2000-06-12 11:46:56
Message-ID: 00061219332103.27884@dyp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hello all,

Here is a patch attached which implement the following strategy of large object handling:
1. There's new system table: pg_largeobject.
2. All large objects are stored inside files not relations.
3. Large objects stored in dir $PGDATA/base/$DATABASE/lo in hashed dirs.
Hashing density can be tuned in config.h.in.
4. For search in pg_largeobject we always use index scan.

That's all. This strategy is better than existing due to:
1. pg_class, pg_index, pg_attributes system tables are not bloated with large objects.
2. Hashing dir mechanism is faster than lots of files in one dir.
3. Files are much faster than relations. Also we save lots of space on indices.

What is not done:
1. Dirs are not removed if there's no any lo's inside. (Is it neccessary???)

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Attachment Content-Type Size
pgsql.lo.new.patch.gz application/x-gzip 14.4 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Denis Perchine 2000-06-12 12:58:26 Version 0.0.4 of 'Not to stuff everything as files in a single directory, hash dirs '
Previous Message Karel Zak 2000-06-12 09:30:59 Re: pg_shadow change