Hi, My application has high data intensive operations (high number of inserts 1500 per sec.). I switched my application from MySQL to PostgreSQL. When I take performance comparison report between mysql and pgsql, I found that, there are huge difference in disk writes and disk space taken. Below stats shows the difference between MySQL and PostgreSQL.
*MySQL**PostgreSQL*Inserts Per Second*15001500Updates Per Second*6.56.5Disk Write Per Second*0.9 MB6.2 MBDatabase Size Increased Per day*13 GB36 GB * approx values Why this huge difference in disk writes and disk space utilization? How can I reduce the disk write and space ? Kindly help me. Please let me know, if you require any other information(such as postgres.conf). Thanks, Ramesh
