Skip site navigation (1) Skip section navigation (2)

Re: Configuring Postgresql for writing BLOB at a high-rate

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "WANGRUNGVICHAISRI, SHIVESH *EXTERN*" <sbw(at)appsig(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Configuring Postgresql for writing BLOB at a high-rate
Date: 2009-07-24 06:14:23
Message-ID: D960CB61B694CF459DCFB4B0128514C203937E5E@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgsql-performance
SHIVESH WANGRUNGVICHAISRI wrote:
> The main question is: how do I configure Postgresql such that 
> it's most efficient for storing large BLOB at a high-rate?

Refering to what you wrote on the web site you quoted,
I would guess that neither tuning WAL nor tuning logging
will have much effect.

My guess would be that the system will be I/O bound from
writing the large objects to disk, so maybe tuning on the
operating system or hardware level might be most effective.

Notice the use of subjunctive mode in the above.
What you should do is: run your test and find out where
the bottleneck is. Are the disks very busy and do you see
significant I/O-wait? Then you're I/O bound.

In that case you could try tuning the I/O part of the kernel
(you didn't say which operating system) and - easiest of all -
get rid of that RAID-5 and get a RAID-1 of fast disks.

Yours,
Laurenz Albe

In response to

pgsql-performance by date

Next:From: Magnus HaganderDate: 2009-07-24 07:17:38
Subject: Re: Postgres user authentification or LDAP authentification
Previous:From: Marc CousinDate: 2009-07-24 05:13:06
Subject: Re: Very big insert/join performance problem (bacula)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group