| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
| 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:24:00 |
| Message-ID: | 20121018142359.GC1982@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Albe Laurenz wrote:
> Arvind Singh 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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Angelico | 2012-10-18 14:37:15 | Re: 9.1/9.2 SERIALIZABLE: expected serialization failure between INSERT and SELECT not encountered |
| Previous Message | Kevin Grittner | 2012-10-18 14:22:24 | Re: 9.1/9.2 SERIALIZABLE: expected serialization failure between INSERT and SELECT not encountered |