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

Configuring Postgresql for writing BLOB at a high-rate

From: "WANGRUNGVICHAISRI, SHIVESH" <sbw(at)appsig(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Configuring Postgresql for writing BLOB at a high-rate
Date: 2009-07-23 23:47:56
Message-ID: 9D9EF0A21FC3914A9248DAE900EEF5FBFEC539@EXCHANGEVS01.appsig.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

 

I posted this question at stackoverflow. Please follow there to see the
question in a nice format as I also posted the code that I used for
benchmarking.

 

http://stackoverflow.com/questions/1174848/postgresql-inserting-blob-at-
a-high-rate

 

The main question is: how do I configure Postgresql such that it's most
efficient for storing large BLOB at a high-rate?

 

Thanks,

 

S.

Responses

pgsql-performance by date

Next:From: Robert HaasDate: 2009-07-24 03:48:27
Subject: Re: Very big insert/join performance problem (bacula)
Previous:From: Robert HaasDate: 2009-07-23 23:22:41
Subject: Re: Performance difference between IN(...) and ANY(...) operator

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