Re: Improving speed of copy

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
andnot necessarily those of my employer