Thread: DB Size question
Good Morning, I know that question is going to be stupid for some of you. Which could be the difference of size between the same table on Postgresql and on Mysql ? Tables are exactly the same : same description, same number of rows,... Cedric
am Thu, dem 25.10.2007, um 8:29:18 +0200 mailte Cedric BUSCHINI folgendes: > Good Morning, > > I know that question is going to be stupid for some of you. > Which could be the difference of size between the same table on > Postgresql and on Mysql ? > Tables are exactly the same : same description, same number of rows,... If you use the blackhole-storage-engine in MySQL, than MySQL needs substantially lesser memory than PostgreSQL... sorry, could not resist. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
Andreas, I m not using that black hole option in Mysql... :-) Saying 'difference of size', I mean a difference in disk usage. Thanks Cedric A. Kretschmer a écrit : > am Thu, dem 25.10.2007, um 8:29:18 +0200 mailte Cedric BUSCHINI folgendes: > >> Good Morning, >> >> I know that question is going to be stupid for some of you. >> Which could be the difference of size between the same table on >> Postgresql and on Mysql ? >> Tables are exactly the same : same description, same number of rows,... >> > > If you use the blackhole-storage-engine in MySQL, than MySQL needs > substantially lesser memory than PostgreSQL... > > > sorry, could not resist. > > > Andreas >
am Thu, dem 25.10.2007, um 9:23:06 +0200 mailte Cedric BUSCHINI folgendes: > Andreas, > > I m not using that black hole option in Mysql... :-) > > Saying 'difference of size', I mean a difference in disk usage. I know that, but i don't know: - which storage engine within mysql - which version (mysql, postgresql) - which datatypes - which compile-options - ... All these may have influence on your question. > > Thanks > > Cedric > > A. Kretschmer a écrit : Please no top-posting. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net