Re: Which database?

[Calvin Browne <calvin at pear.orange-tree.alt.za>]

> 
> Hi,
> 
> I am no expert on the subject but have had a little experience......
> 
> We were recently visiting the Brazilian Internet Steering committee where
> they operate the .br tld (note that this includes almost 1m records and is
> at least 7x the size of .co.za) . I was pleased to see that this is all done
> on a BSD machine. Clearly the database is of crucial importance to them.

Ummm - .br have ~400 000 names, we have ~100 000 names,
with our database consisting of 12 tables, with 2366348 records
across those tables.(1)

Postgres 7.0.3, on a Linux 2.2.17 smp kernel, 1 gig of ram,
and 4x2meg 700mhz xeons....

we need transactions, which we can not do with mySQL......

--Calvin

(1) as of my composing this email.

------------------------* My opinions are mine *------------------------------
 Calvin Browne calvin at UniForum.org.za c at lvin.co.za
               Office phone: 080 314 0077        +27 11 314-0077
               http://orange-tree.alt.za Mobile: +27 83 303-0663
               Call me for Linux/Internet consulting 
------------------------------------------------------------------------------

-----
This is the afnog mailing list, managed by Majordomo 1.94.4

To send a message to this list, e-mail afnog at afnog.org
To send a request to majordomo, e-mail majordomo at afnog.org and put
your request in the body of the message (i.e use "help" for help)

This list is maintained by owner-afnog at afnog.org