PostgreSQL vs mySQL, any performance difference for large queries?

Поиск
Список
Период
Сортировка
От Jan
Тема PostgreSQL vs mySQL, any performance difference for large queries?
Дата
Msg-id 1130186243.866266.146150@g47g2000cwa.googlegroups.com
обсуждение исходный текст
Ответы Re: PostgreSQL vs mySQL, any performance difference for large queries?  (Alex Turner <armtuk@gmail.com>)
Re: PostgreSQL vs mySQL, any performance difference for  (Jeff Davis <pgsql@j-davis.com>)
Re: PostgreSQL vs mySQL, any performance difference for  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
I need a database capable of storing at least 12 million records per
table, mostly used for batch queries. Basically an invoice database.
Some tables could potentially store 100 million records.

mySQL5 contains many of the features or PostgreSQL, and I doubt that I
need all these features. Are there any spefic benefits in query
performance or reliability of going with PostgreSQL?

Secondary need is a database where 200 users will need to perform
lookups, probably using Windows PC's. Most likely only a handful will
perform lookups simultanously.


В списке pgsql-general по дате отправления:

Предыдущее
От: "shakahshakah@gmail.com"
Дата:
Сообщение: Re: Why is this function wrong
Следующее
От: ellis@no.spam ()
Дата:
Сообщение: Re: Recovery after server crash