Thread: general features

general features

From
"Badawy, Mohamed"
Date:

Hi all

am very new to postgres & actually am just collecting information about but I having a problem with time so I was asking if someone could help me with quick anserws about these features in postgres.

 

1-max amount of available storage data.
2-Clustering support.
3-price.
4-speed.

 

 

 

Best Regards,,,

 

Mohamed Badawy

 

 

 


THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL.

If you are not the intended recipient you are notified that any disclosure, reproduction, copying, distribution, or action taken in reliance on the contents of this information is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed,arrive late or incomplete, or contain viruses. The company/sender accepts no liability for any changes made to this email during transmission or any damage caused by any virus transmitted by this email. Any views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the company. The company/sender accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing.

AMS Advanced Medical Services GmbH, Mannheim - Registered office: Am Exerzierplatz 2, 68167 Mannheim - Register court: Amtsgericht  Mannheim, HRB 7462  - Managing Director: Dr. Christian Carls

Re: general features

From
"A. Kretschmer"
Date:
am  Sun, dem 03.06.2007, um 10:34:47 +0200 mailte Badawy, Mohamed folgendes:
> Hi all
>
> am very new to postgres & actually am just collecting information about but I
> having a problem with time so I was asking if someone could help me with quick
> anserws about these features in postgres.
>
>
>
> 1-max amount of available storage data.

http://www.postgresql.org/docs/faqs.FAQ.html#item4.4


> 2-Clustering support.

What do you mean exactly?


> 3-price.

http://www.postgresql.org/docs/faqs.FAQ.html#item1.3


> 4-speed.

very high ;-)


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: general features

From
PFC
Date:
> 1-max amount of available storage data.

    How many hard disks can you buy ?

> 2-Clustering support.

    Please be more precise.

> 3-price.

    Free.

> 4-speed.

    Proportional to the expertise of the DBA.
    Postgres can be extremely fast if used correctly, it can totally suck if
the database is badly designed.
    But this is completely normal. It is as fast as the other major players,
and all of them need expertise to work well.
    If you're a newbie, you'll make newbie errors, fortunately this list has
many friendly & knowledgeable people who can help you, and the docs are
excellent.

> THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL.

    Aw. Come on.

Re: general features

From
"Badawy, Mohamed"
Date:

 

Thanks for all of the replies,,,

 

What I mean by clustering is to put the database on many machines.

 

 

Best Regards,,,

 

Mohamed Badawy

 

 

 


THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL.

If you are not the intended recipient you are notified that any disclosure, reproduction, copying, distribution, or action taken in reliance on the contents of this information is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed,arrive late or incomplete, or contain viruses. The company/sender accepts no liability for any changes made to this email during transmission or any damage caused by any virus transmitted by this email. Any views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the company. The company/sender accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing.

AMS Advanced Medical Services GmbH, Mannheim - Registered office: Am Exerzierplatz 2, 68167 Mannheim - Register court: Amtsgericht  Mannheim, HRB 7462  - Managing Director: Dr. Christian Carls

Re: general features

From
Ron Johnson
Date:
On 06/03/07 09:08, Badawy, Mohamed wrote:
[snip]
>
> Thanks for all of the replies,,,
>
> What I mean by clustering is to put the database on many machines.

Single database on many machines?

Do you mean federation/horizontal scaling, or DR replication or
something different.  PostgreSQL has master-slave replication using
Slony-1.

If you mean simultaneous access to the same disks from multiple
machines without corrupting the data, you'll have to go to a
proprietary system.  10K (15K if you've got the scratch) RPM RAID10,
8GB RAM and a couple of dual-core Opterons is a *really* fast
database box.  You might not need more than that.

But if you *do* need the continuous uptime that shared-disk
clustering and rolling in-place upgrades gives you, then Rdb/VMS
can't be beat.  It'll *cost*, though.

--
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!