On Fri, 2002-09-20 at 08:52, Shridhar Daithankar wrote: > Besides there is issue of space. Mysql takes 1.4GB space for 1.2GB text data > and postgresql takes 3.2GB of space. Even with 40 bytes per row overhead > mentioned in FAQ, that should come to around 1.7GB, counting for 40% increase > in size. Vacuum was run on database. >
How did you calculate the size of database? If you used "du" make sure you do it in the data/base directory as to not include the WAL files. -- Best Regards, Mike Benoit NetNation Communication Inc. Systems Engineer Tel: 604-684-6892 or 888-983-6600 --------------------------------------- Disclaimer: Opinions expressed here are my own and not necessarily those of my employer ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
