| From: | Mike Benoit <mikeb(at)netnation(dot)com> |
|---|---|
| To: | shridhar_daithankar(at)persistent(dot)co(dot)in |
| Cc: | Pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Improving speed of copy |
| Date: | 2002-09-20 17:27:13 |
| Message-ID: | 1032542833.7433.11.camel@mikeb.staff.netnation.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-09-20 17:31:27 | Re: Win32 rename()/unlink() questions |
| Previous Message | Bruce Momjian | 2002-09-20 17:12:17 | Re: regression test failure in CVS HEAD |