Postgres Pro
Downloads
Home   >   mailing lists

Configuring Postgresql for writing BLOB at a high-rate - Mailing list pgsql-performance

From WANGRUNGVICHAISRI, SHIVESH
Subject Configuring Postgresql for writing BLOB at a high-rate
Date
Msg-id 9D9EF0A21FC3914A9248DAE900EEF5FBFEC539@EXCHANGEVS01.appsig.com
Whole thread Raw
Responses Re: Configuring Postgresql for writing BLOB at a high-rate
List pgsql-performance
Tree view

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.

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Performance difference between IN(...) and ANY(...) operator
Next
From: Robert Haas
Date:
Subject: Re: Very big insert/join performance problem (bacula)