On lör, 2012-07-14 at 10:41 +0200, Joel Jacobson wrote:
> On Fri, Jul 13, 2012 at 9:41 PM, Peter Eisentraut <pete...@gmx.net> wrote:
> 
> > Personally, I hate this proposed nested directory structure.  I would
> > like to have all objects in one directory.
> >
> > But there is a lot of "personally" in this thread, of course.
> 
> 
> Why do you hate it?
> 
> It's a bit like saying,
>  - I hate database normalization, better to keep all rows in one single
> table.
> or even,
>  - I hate directories.

To a certain extent, yes, I hate (excessive use of) directories.

> I have thousands of objects, it would be a total mess to keep them all in a
> single directory.

Thousands of objects could be a problem, in terms of how the typical
file system tools scale.  But hundreds or a few thousand not
necessarily.  It's easy to browse, filter, and sort using common tools,
for example.

> Using a normalized directory structure makes sense for the SCM use-case,

If there is a theory of "normalization" for hierarchical databases, I
don't know it but would like to learn about it.

> I haven't seen any projects where all the files are kept in one directory.

Well, of course everyone uses directories in moderation.  But you might
want to take a look at the gcc source code.  You'll love it. ;-)



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to