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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
