[GENERAL] 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 --
Re: [GENERAL] general features
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] general features
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. ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] general features
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] general features
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! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[GENERAL] Features
Hi Folks, I know this one has been asked alot, but since i can't search, i'm gonna re-ask. 1: Reliablility - is there any documents out there regarding stability and reliablilty of postgresql 2: replication - still in exotic list ? there is huge market demand, and lots of people willing to throw cash into it. 3: don't think it's been asked, but does postgresql have any XML support, or has anyone looked into it ? Jeff MacDonald [EMAIL PROTECTED]
