On Wed, 17 Dec 2014 13:55:46 +0100 Thomas Kellerer <spam_ea...@gmx.net> wrote: > > Another downside you didn't mentioned is the fact that you have to distribute > the files in the filesystem properly. > Having thousands or even millions of files in a single directory is not going > to be maintenance friendly either. >
That's not a very hard problem to solve. Just write a script that splits the directory into 1000 file chunks, I did it with perl from scratch in a few hours. Now my database dumps in seconds, and rsync takes care of new files just as fast. -- Salutations, Vincent Veyron https://libremen.com/ Legal case, contract and insurance claim management software -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general