Обсуждение: Question
In the past week, one guy of Unix Group in Colombia say: "Postgrest in production is bat, if the power off in any time the datas is lost why this datas is in plain files. Postgrest no ssupport data bases with more 1 millon of records". Wath tell me in this respect?, is more best Informix as say Ing. Alejandro Lemus G. Radio Taxi Aeropuerto S.A. Avenida de las Américas # 51 - 39 Bogotá - Colombia Tel: 571-4470694 / 571-4202600 Ext. 260 Fax: 571-2624070 email: alejandro_lemus2003@yahoo.com __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/
Perhaps choose a better subject than "question" next time? Alejandro Lemus wrote: > In the past week, one guy of Unix Group in Colombia > say: "Postgrest in production is bat, if the power off > in any time the datas is lost Wrong. And it's called "PostgreSQL". > why this datas is in > plain files. Postgrest no ssupport data bases with > more 1 millon of records". Wrong. > Wath tell me in this respect?, is more best Informix > as say Your contact in the Unix Group in Columbia obviously talks on subjects where he knows little. Perhaps re-evaluate anything else you've heard from him. You can find details on PostgreSQL at http://www.postgresql.org/, including the manuals: http://www.postgresql.org/docs/8.0/static/index.html The FAQ: http://www.postgresql.org/docs/faq/ Spanish/Brazilian communities, which might prove useful http://www.postgresql.org/community/international PostgreSQL is licensed under the BSD licence, which means you can freely download or deploy it in a commercial setting if you desire. -- Richard Huxton Archonet Ltd
> In the past week, one guy of Unix Group in Colombia > say: "Postgrest in production is bat, if the power off in any > time the datas is lost why this datas is in plain files. > Postgrest no ssupport data bases with more 1 millon of records". > Wath tell me in this respect?, is more best Informix as say Both these statements are completely incorrect. Unlike some other "database systems", PostgreSQL *does* survive power loss without any major problems. Assuming you use a metadata journailng filesystem, and don't run with non-battery-backed write-cache (but no db can survive that..) And having a million records is no problem at all. You may run into considerations when you're talking billions, but you can do that as well - it just takes a bit more knowledge before you can do it right. //Magnus
As a sometimes Informix and PostgreSQL DBA, I disagree with the contentions below. We have many tables with 10s of millionsof rows in Postgres. We have had (alas) power issues with our lab on more than one occasion and the afflicted servershave recovered like a champ, every time. This person may not like postgres (or very much likes Informix), but he shouldn't conjure up spurious reasons to supporthis/her prejudice. Informix is an excellent product, but it can be costly for web related applications. PostgeSQL is also an excellent database.Each has differences which may make the decision between the two of them clear. But facts are necessary to havea real discussion. Greg WIlliamson DBA GlobeXplorer LLC -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Alejandro Lemus Sent: Monday, July 11, 2005 6:00 AM To: pgsql-performance@postgresql.org Subject: [PERFORM] Question In the past week, one guy of Unix Group in Colombia say: "Postgrest in production is bat, if the power off in any time the datas is lost why this datas is in plain files. Postgrest no ssupport data bases with more 1 millon of records". Wath tell me in this respect?, is more best Informix as say Ing. Alejandro Lemus G. Radio Taxi Aeropuerto S.A. Avenida de las Américas # 51 - 39 Bogotá - Colombia Tel: 571-4470694 / 571-4202600 Ext. 260 Fax: 571-2624070 email: alejandro_lemus2003@yahoo.com __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend !DSPAM:42d26e2065882109568359!