| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Alvaro Herrera *EXTERN*" <alvherre(at)2ndquadrant(dot)com> |
| Cc: | "Arvind Singh *EXTERN*" <arvindps(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Improve MMO Game Performance |
| Date: | 2012-10-18 14:49:32 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C208902A46@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera wrote:
>>> Are there any particular settings or methods available to improve
Just
>>> insert_table operations
>>
>> The obvious ones:
>> - Wrap several of them in a transaction.
>> - Increase checkpoint_segments.
>> - Set fsync=off and hope you don't crash.
>
> I think it would work to set asynchronous_commit=off for the
> transactions that insert moves. That way, the fsync flushes happen in
> the background and are batched. Raising wal_buffers is probably a
good
> idea, and keep an eye on how the walwriter is doing.
I guess you mean synchronous_commit=off :^)
Yes, I forgot that one.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2012-10-18 15:46:50 | Re: BUG #6510: A simple prompt is displayed using wrong charset |
| Previous Message | GMAIL | 2012-10-18 14:47:35 | postgresql error while connecting to cluster with pgadmin |