pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion
4+ messages / 4 participants
[nested] [flat]
* Question
@ 2005-07-11 12:59 Alejandro Lemus <alejandro_lemus2003@yahoo.com>
0 siblings, 1 reply; 4+ messages in thread
From: Alejandro Lemus @ 2005-07-11 12:59 UTC (permalink / raw)
To: pgsql-performance
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/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Question
@ 2005-07-11 13:29 Richard Huxton <dev@archonet.com>
parent: Alejandro Lemus <alejandro_lemus2003@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: Richard Huxton @ 2005-07-11 13:29 UTC (permalink / raw)
To: Alejandro Lemus <alejandro_lemus2003@yahoo.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Question
@ 2005-07-11 13:34 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 4+ messages in thread
From: Magnus Hagander @ 2005-07-11 13:34 UTC (permalink / raw)
To: Alejandro Lemus <alejandro_lemus2003@yahoo.com>; pgsql-performance
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Question
@ 2005-07-11 23:26 Gregory S. Williamson <gsw@globexplorer.com>
0 siblings, 0 replies; 4+ messages in thread
From: Gregory S. Williamson @ 2005-07-11 23:26 UTC (permalink / raw)
To: Alejandro Lemus <alejandro_lemus2003@yahoo.com>; pgsql-performance
As a sometimes Informix and PostgreSQL DBA, I disagree with the contentions below. We have many tables with 10s of millions of rows in Postgres. We have had (alas) power issues with our lab on more than one occasion and the afflicted servers have 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 support his/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 have a 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!
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-07-11 23:26 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-11 12:59 Question Alejandro Lemus <alejandro_lemus2003@yahoo.com>
2005-07-11 13:29 ` Richard Huxton <dev@archonet.com>
2005-07-11 13:34 Re: Question Magnus Hagander <mha@sollentuna.net>
2005-07-11 23:26 Re: Question Gregory S. Williamson <gsw@globexplorer.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox