pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: hardware performance and some more
Date: Fri, 25 Jul 2003 19:33:26 +0530
Message-ID: <3F218606.25557.29D818@localhost> (raw)
In-Reply-To: <3F200C90.5050001@talisys.com>

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




view thread (15+ messages)  latest in thread

Message-ID: <3F218606.25557.29D818@localhost>
Permalink:  ../3F218606.25557.29D818@localhost/
Also on:    postgresql.org/message-id/3F218606.25557.29D818@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in, pgsql-hackers@postgresql.org
  Subject: Re: hardware performance and some more
  In-Reply-To: <3F218606.25557.29D818@localhost>
  References: <3F200C90.5050001@talisys.com> <3F218606.25557.29D818@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox