[Pgcluster-general] Read operations in PgCluster 1.9

[Niranjan K]

Hello,

I was evaluating the pgcluster-1.9.0rc5 and the configurations are 2 node
cluster with 1 Cluster DB in each server (Master in 1 node & Slave in
another node) and 1 replicator in master node.
When i execute a tool (DB Benchmark), which executes SELECT SQL statements,
the PgCluster expects 'PgReplicate' process to be up & running. I guess this
is required only for INSERT, UPDATE, DELETE statements. I had brought down
the replicator process intensionally because the performance (atleast for
SELECT statements) was not what we expected. Currently we get 115
transactions/ second in PgCluster and in case of single node PotsgreSQL we
get 2180 transactions/second.
What could be the potential problem. Why there is a need for SELECT query to
be submitted to Replicator process?

I have increased the shared_buffers from 32MB to 128 MB, so that the read
rows have sufficient space in the cache. I also tried executing the DB
Benchmark tool with single thread and with 10 threads. But could not see any
major improvement.

I'am using ODBC driver "psqlodbc-08.03.0200".

regards,
Niranjan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20080611/66d55057/attachment.html