[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slony1-general
Subject:    Re: [Slony1-general] Slony with PGSQL 8
From:       Tim Goodaire <tgoodair () ca ! afilias ! info>
Date:       2006-04-28 19:19:01
Message-ID: 20060428191901.GO61224 () dba6 ! int ! libertyrms ! com
[Download RAW message or body]


On Fri, Apr 28, 2006 at 11:00:55AM +0200, Michael Vodep wrote:
> This is my first cluster and i don't have any experience with LB&FO.  
> What's the usual way  to distribute heavy load on PostgreSQL servers?

You could take a look at pgpool for load balancing:
http://pgpool.projects.postgresql.org/

> Are there any sample slonik scripts out there? The sample scirpt  
> provided at the official docu (pg_bench sample) didn't help me so  
> much :-/

You should take a look at the altperl scripts. They're included in the slony1
tarball, and they make writing slonik scripts much easier. 

-- 
Tim Goodaire    416-673-4126    tgoodair@ca.afilias.info
Database Administrator, Afilias Canada Corp.

[Attachment #3 (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]