Thread: Question

Question

From
Alejandro Lemus
Date:
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/

Re: Question

From
Richard Huxton
Date:
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

Re: Question

From
"Magnus Hagander"
Date:
> 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

Re: Question

From
"Gregory S. Williamson"
Date:
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!