Hey, Table 1 has 29 columns. Row length median is 78. Row size median is 126 bytes. Fixed table format.
Table 2 has 6 columns. Row length median is 22. Row size median is 96 bytes. Fixed table format. There are three indexes on each of these tables. Table 1 has an index on 4 columns, and another two indexes on one column each. Table 2 has an index on 5 columns, and another two indexes on one column each. Regards, Andrew -----Original Message----- From: Ow Mun Heng [mailto:[EMAIL PROTECTED] Sent: Thursday, 26 July 2007 6:45 PM To: Andrew Armstrong Cc: mysql@lists.mysql.com Subject: Re: Data Warehousing and MySQL vs PostgreSQL On Thu, 2007-07-26 at 18:37 +1000, Andrew Armstrong wrote: > Hello, > > > > I am seeking information on best practices with regards to Data Warehousing > and MySQL. I am considering moving to PostgreSQL. > * Table 1: 80,000,000 rows - 9.5 GB > * Table 2: 1,000,000,000 rows - 8.9 GB Just curious, how many columns are there in each table? as the database seems small to me -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]