Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve MMO Game Performance - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Improve MMO Game Performance
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208901F74@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Improve MMO Game Performance  (Arvind Singh <arvindps@hotmail.com>)
Responses Re: Improve MMO Game Performance  (Chris Angelico <rosuav@gmail.com>)
Re: Improve MMO Game Performance  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
Tree view 
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.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Postgres DB Migration from 8.3 to 9.1
Next
From: John Nash
Date:
Subject: WebSphere Application Server support for postgres