| From: | Marti Raudsepp <marti(at)juffo(dot)org> |
|---|---|
| To: | Divakar Singh <dpsmails(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Insert performance with composite index |
| Date: | 2010-11-01 13:04:46 |
| Message-ID: | AANLkTi=2MRg-yjdg20NsfksqvDjWXKPvw0-kxdG1nFFz@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Nov 1, 2010 at 14:56, Divakar Singh <dpsmails(at)yahoo(dot)com> wrote:
> Thanks for your tips. i will try those.
> I am on Solaris Sparc 5.10
Sorry, I assumed you were running Linux. But still it could be the
same problem as I had.
Be careful changing your wal_sync_method, as it has the potential to
corrupt your database. I have no experience with Solaris.
For what it's worth, Jignesh Shah recommends using
wal_sync_method=fsync on Solaris:
http://blogs.sun.com/jkshah/entry/postgresql_on_solaris_better_use
http://blogs.sun.com/jkshah/entry/postgresql_wal_sync_method_and
Regards,
Marti
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cédric Villemain | 2010-11-01 13:57:56 | Re: Insert performance with composite index |
| Previous Message | Divakar Singh | 2010-11-01 12:56:13 | Re: Insert performance with composite index |