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 at ca.afilias.info
Database Administrator, Afilias Canada Corp.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060428/6e5c0095/attachment.bin