| From: | J Ramesh Kumar <rameshj1977(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | High Disk write and space taken by PostgreSQL |
| Date: | 2012-08-16 03:23:06 |
| Message-ID: | CA+-36iFtmVsuvrXbahBX=29Sn-9XsaZpWHQfg9dmOf3SEkJcug@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Barton | 2012-08-16 03:36:53 | Re: High Disk write and space taken by PostgreSQL |
| Previous Message | Josh Berkus | 2012-08-16 00:25:06 | Re: 7k records into Sort node, 4.5m out? |