Postgres Pro
Downloads
Home   >   mailing lists

Re: Improving speed of copy - Mailing list pgsql-hackers

From Mike Benoit
Subject Re: Improving speed of copy
Date
Msg-id 1032542833.7433.11.camel@mikeb.staff.netnation.com
Whole thread Raw
In response to Improving speed of copy  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Improving speed of copy  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: regression test failure in CVS HEAD
Next
From: Bruce Momjian
Date:
Subject: Re: Win32 rename()/unlink() questions