Re: Improving speed of copy

Поиск
Список
Период
Сортировка
От Mike Benoit
Тема Re: Improving speed of copy
Дата
Msg-id 1032542833.7433.11.camel@mikeb.staff.netnation.com
обсуждение исходный текст
Ответ на Improving speed of copy  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: Improving speed of copy  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список 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
andnot necessarily those of my employer
 



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: regression test failure in CVS HEAD
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Win32 rename()/unlink() questions