From: | "Kevin Carpenter" <kevin(at)valenfor(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Database conversion woes... |
Date: | 2004-02-03 16:42:59 |
Message-ID: | E1Ao3db-0002sp-EL@alexandria15.alexsrv15.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello everyone,
I am doing a massive database conversion from MySQL to Postgresql for a
company I am working for. This has a few quirks to it that I haven't
been able to nail down the answers I need from reading and searching
through previous list info.
For starters, I am moving roughly 50 seperate databases which each one
represents one of our clients and is roughly 500 megs to 3 gigs in size.
Currently we are using the MySQL replication, and so I am looking at
Mammoths replicator for this one. However I have seen it only allows on
DB to be replicated at a time. With the size of each single db, I don't
know how I could put them all together under one roof, and if I was
going to, what are the maximums that Postgres can handle for tables in
one db? We track over 2 million new points of data (records) a day, and
are moving to 5 million in the next year.
Second what about the physical database size, what are the limits there?
I have seen that it was 4 gig on Linux from a 2000 message, but what
about now? Have we found way's past that?
Thanks in advance, will give more detail - just looking for some open
directions and maybe some kicks to fuel my thought in other areas.
Thanks,
--
kevin(at)valenfor(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-03 16:46:05 | Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? |
Previous Message | Joshua D. Drake | 2004-02-03 16:19:17 | Re: MySQL+InnoDB vs. PostgreSQL test? |