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

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 (view raw, whole thread or download thread mbox)
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
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
FidoNet: 2:5000/120.5

Description: application/x-gzip (14.4 KB)


pgsql-patches by date

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

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