Hello,
Yes gzip compression can be used for compressing WAL traffic during
streaming replication Following tools can be used in this regard.
SSL compression-SSL support is built in PostgreSQL. You need to ensure you
have OpenSSL library support in your PostgreSQL installation.
Also, you can compr
Hello,
Yes, gzip compression can be used for compressing WAL traffic during
streaming replication Following tools can be used in this regard.
SSL compression-SSL support is built in PostgreSQL. You need to ensure
you have OpenSSL library support in your PostgreSQL installation.
Also, you can comp
for your suggestion.
-Rahila
On Fri, Oct 25, 2013 at 10:34 PM, Scott Marlowe wrote:
> On Fri, Oct 25, 2013 at 8:29 AM, Rahila Syed wrote:
>> Hello All,
>>
>> I am using jdbcrunner-1.2 to run PostgreSQL performance tests. For
>> certain tests, i need to increase the CP
anks a lot for your suggestion. Using select only queries helped me
lower % CPU time spent on IO. Also , increasing number of threads
helped loading CPU around 87 to 90 %.
-Rahila
On Sat, Oct 26, 2013 at 7:53 PM, Tomas Vondra wrote:
> On 25.10.2013 19:04, Scott Marlowe wrote:
>> On Fr
Hello All,
I am using jdbcrunner-1.2 to run PostgreSQL performance tests. For
certain tests, i need to increase the CPU usage of the servers
especially at user level.
I tried using both tpcc and tpcb load with scale factor of 100. Even
after setting the number of client connections as high as 420,
Hello,
Yes. Multimedia data can be stored in PostgreSQL database using either bytea
and BLOB types. Depending on size either can be used. BLOB is meant for
storing large data.
Various interfaces are provided to access such data.
Following link can be referred for that.
http://www.postgresql.org/d
