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

Re: Patch for better large objects support

From: Chris Bitmead <chris(at)bitmead(dot)com>
To: Denis Perchine <dyp(at)perchine(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Patch for better large objects support
Date: 2000-06-12 13:17:28
Message-ID: 3944E2E8.41BEB03@bitmead.com (view raw or flat)
Thread:
Lists: pgsql-patches
Will anybody want to use this when TOAST comes to be?

Denis Perchine wrote:
> 
> 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
> ----------------------------------
> 
>   ------------------------------------------------------------------------
>                             Name: pgsql.lo.new.patch.gz
>    pgsql.lo.new.patch.gz    Type: application/x-gzip
>                         Encoding: base64

In response to

Responses

pgsql-patches by date

Next:From: David ReidDate: 2000-06-12 13:46:20
Subject: BeOS Diff Take 3
Previous: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 '

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