On Sat, Oct 24, 2009 at 1:46 PM, Tawita Tererei <nevita0305@xxxxxxxxxxx> wrote: > In addition to this what about MySQL, how much data (records) that can be > managed with it? That's a question for the mysql mailing lists / forums really. I do know there's some artificial limit in the low billions that you have to create your table with some special string to get it to handle more. As for pgsql, we use one of our smaller db servers to keep track of our stats. It's got a 6 disk RAID-10 array of 2TB SATA 5400 RPM drives (i.e. not that fast really) and we store about 2.5M rows a day in it. So in 365 days we could see 900M rows in it. Each daily partition takes about 30 seconds to seq scan. On our faster servers, we can seq scan all 2.5M rows in about 10 seconds. PostgreSQL can handle it, but don't expect good performance with a single 5400RPM SATA drive or anything. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
