Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

3 Answers 3

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.

share|improve this answer

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.

share|improve this answer
1  
I know how to optimze postgresql in general, I want to have specific information about optimization for blobs. –  Mauli Aug 7 '09 at 8:55

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.

share|improve this answer
    
Unfortunately that doesn't work with Artifactory, they have some kind of custom implementation of their storage. –  Mauli Oct 13 '09 at 8:26

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.