Postgresql – How to optimize postgresql for use with Jackrabbit (a lot of blobs)

optimizationpostgresql

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?

Best Answer

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.

Related Solutions

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

OK, got it from someone else. This query should do the trick:

select *
from pg_stat_activity
where datname = 'mydatabasename';

Postgresql – How to optimize a postgreSQL server for a “write once, read many”-type infrastructure

Change some configuration settings in postgresql.conf: Writing: increase the wal-settings Reading: increase shared_buffers and set work_mem to an amount the planner can do its magic.

There several settings, you have to check and test.

RAID 10 is great for writing, reading will be fine as well. A good RAID-card with a lot of RAM and battery backup, will help a lot.

And, RAM, RAM and RAM. You can't have too much.

Best Answer

Related Solutions

Postgresql – How to see active connections and “current activity” in PostgreSQL 8.4

Postgresql – How to optimize a postgreSQL server for a “write once, read many”-type infrastructure

Related Topic