Thread: general features
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
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
> 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.
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
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!