Re: Improving speed of copy

On 20 Sep 2002 at 10:27, Mike Benoit wrote:

> 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.

OK latest experiments, I turned number of buffers 15K and fsync is disabled..
Load time is now 1250 sec.

I noticed lots of notices in log saying, XLogWrite: new log files created.. I
am pushing wal_buffers to 1000 and wal_files to 40 to test again.. I hope it
gives me some required boost..

And BTW about disk space usage, it's 2.6G with base pg_xlog taking 65M. still
not good..

Will keep you guys updated..

Bye
Shridhar

--
It is necessary to have purpose. -- Alice #1, "I, Mudd", stardate 4513.3