Re: [PERFORM] Distant mirroring

2008-08-12 Thread dforums
Tx to all. I reach the same reflection on partitionning the data to those tables. And postgresql is giving very good tools for that with the rules features. I got the SAS server for immediate fix. But I'm looking for buying a machine that will handle my needs for more long time. Regarding p

Re: [PERFORM] Distant mirroring

2008-08-11 Thread Scott Marlowe
On Mon, Aug 11, 2008 at 8:26 AM, dforums <[EMAIL PROTECTED]> wrote: > Houlala > > I got headache !!! > > So please help...;; > > "Assuming they all happen from 9 to 5 and during business days only, > that's about 86 transactions per second. Well within the realm of a > single mirror set to

Re: [PERFORM] Distant mirroring

2008-08-11 Thread Fernando Hevia
> -Mensaje original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] En nombre de dforums > Enviado el: Lunes, 11 de Agosto de 2008 11:27 > Para: Scott Marlowe; pgsql-performance@postgresql.org > Asunto: Re: [PERFORM] Distant mirroring > > Houlala > &

Re: [PERFORM] Distant mirroring

2008-08-11 Thread dforums
Houlala I got headache !!! So please help...;; "Assuming they all happen from 9 to 5 and during business days only, that's about 86 transactions per second. Well within the realm of a single mirror set to keep up if you don't make your db work real fat." OK i like, But my reality is t

Re: [PERFORM] Distant mirroring

2008-08-09 Thread Scott Marlowe
On Sat, Aug 9, 2008 at 11:29 AM, dforum <[EMAIL PROTECTED]> wrote: > Hello, > > I'm trying to install a solution to permit me to : > - Secure the datas, without RAID Nothing beats a simple mirror set for simplicity while protecting the data, and for a pretty cheap cost. How much is your data wort

[PERFORM] Distant mirroring

2008-08-09 Thread dforum
Hello, I'm trying to install a solution to permit me to : - Secure the datas, without RAID - Giving ability to increase the potentiality of the database towards the needs. I have read about slony, DRBD, pgpool I don't find the good system to do what I want. I manage for now 50 millions o