0

Jackrabbit is a implementation of the JCR (Java Content Repository API), and it is used for instance by Artifactory which stores the maven artifacts in it. Therefore most of the stuff consists of blobs.

What configuration options do I need to tweak that postgres is optimized to this scenario?

3 Answers 3

1

While blobs take up space, they won't be written to often (I expect), so you may not need any tuning.

If it turns out you do, first move the tables with blobs into their own tablespace, and possibly tweak the disk performance on that tablespace by using raid1 for faster reads.

0

Start from this page in the PostgreSQL wiki. If that's not enough, you're going to have to do a much more detailed analysis of exactly what needs to be done. But most likely, that guide will take you as far as you need to go.

That one is for 8.3, which you appear to look for here. But you should really consider using 8.4 instead, since that's the latest version. Most of the advice in that article is still correct - just a couple of parameters that no long exist and can be ignored.

1
  • 1
    I know how to optimze postgresql in general, I want to have specific information about optimization for blobs.
    – Mauli
    Aug 7, 2009 at 8:55
0

Your best bet is to not store them in the database. Look at one of the many distributed file stores and write your own datastore class to store the binary data in there. It has the advantages of giving you scalability, keeps your databases small, which improves dumps and restores, and your data is replicated, giving you better reliability.

1
  • Unfortunately that doesn't work with Artifactory, they have some kind of custom implementation of their storage.
    – Mauli
    Oct 13, 2009 at 8:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .