| From: | "Dave Dutcher" <dave(at)tridecap(dot)com> |
|---|---|
| To: | "'keshav upadhyaya'" <ukeshav2009(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: What is the role of #fsync and #synchronous_commit in configuration file . |
| Date: | 2009-10-06 12:49:37 |
| Message-ID: | 565BB5E11A904BDDBFAB0826B0BCD088@tridecap.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-performance |
>From: keshav upadhyaya
>Subject: [PERFORM] What is the role of #fsync and #synchronous_commit in
configuration file .
>
>Hi ,
>I want to imporve the performance for inserting of huge data in my table .
>I have only one idex in table .
>
>First question - i want to know the role played by
>
> #fsync = on and
> #synchronous_commit = on
>
>I want to understand more in details what exactly had happened one is made
them "off" ,
>is it dangerous to do this ? as it will not sync the data in each commit .
The settings are described in the docs:
http://www.postgresql.org/docs/8.4/interactive/runtime-config-wal.html
If you turn fsync off, you risk data loss in case of power or hardware
failure.
Dave
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Kupershmidt | 2009-10-06 15:38:25 | Re: What is the role of #fsync and #synchronous_commit in configuration file . |
| Previous Message | keshav upadhyaya | 2009-10-06 07:28:01 | What is the role of #fsync and #synchronous_commit in configuration file . |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaul Dar | 2009-10-06 13:16:27 | Dumping + restoring a subset of a table? |
| Previous Message | Axel Rau | 2009-10-06 10:26:53 | Re: Best suiting OS |