Horton

Re: Improving speed of copy

Mike Benoit <mikeb@netnation.com>

View thread View on postgr.es
From: Mike Benoit <mikeb@netnation.com>
To: shridhar_daithankar@persistent.co.in
Cc: Pgsql-hackers@postgresql.org
Date: 2002-09-20T17:27:13Z
Lists: pgsql-hackers 
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