Re: hardware performance and some more

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: hardware performance and some more
Date: 2003-07-25 14:03:26
Message-ID: 3F218606.25557.29D818@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On 24 Jul 2003 at 9:42, William Yu wrote:

> As far as I can tell, the performance impact seems to be minimal.
> There's a periodic storm of replication updates in cases where there's
> mass updates sync last resync. But if you have mostly reads and few
> writes, you shouldn't see this situation. The biggest performance impact
> seems to be the CPU power needed to zip/unzip/encrypt/decrypt files.

Can you use WAL based replication? I don't have a URL handy but there are
replication projects which transmit WAL files to another server when they fill
in.

OTOH, I was thinking of a simple replication theme. If postgresql provides a
hook where it calls an external library routine for each heapinsert in WAL,
there could be a simple multi-slave replication system. One doesn't have to
wait till WAL file fills up.

Of course, it's upto the library to make sure that it does not hold postgresql
commits for too long that would hamper the performance.

Also there would need a receiving hook which would directly heapinsert the data
on another node.

But if the external library is threaded, will that work well with postgresql?

Just a thought. If it works, load-balancing could be lot easy and near-
realtime..

Bye
Shridhar

--
We fight only when there is no other choice. We prefer the ways ofpeaceful contact. -- Kirk, "Spectre of the Gun", stardate 4385.3

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-07-25 14:53:53 Re: v7.3.4 bundled ...
Previous Message Tom Lane 2003-07-25 13:10:51 Re: SELECT FOR UPDATE

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Johnson 2003-07-25 14:19:56 Re: hardware performance and some more
Previous Message Shridhar Daithankar 2003-07-25 13:59:08 Re: hardware performance and some more