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

From Albe Laurenz
Subject Re: Improve MMO Game Performance
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2089027E5@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Improve MMO Game Performance  (Chris Angelico <rosuav@gmail.com>)
List pgsql-general
Chris Angelico wrote:
>> - Set fsync=off and hope you don't crash.
>
> Ouch. I might consider that for a bulk import operation or something,
> but not for live usage. There's plenty else can be done without
> risking data corruption.

I didn't mean that to be an alternative that anybody should
consider for production use.

I don't think that there are so many ways to speed up
INSERTs.  Can you think of some that I have missed?

Yours,
Laurenz Albe


pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: Improve MMO Game Performance
Next
From: "Albe Laurenz"
Date:
Subject: Re: 9.1/9.2 SERIALIZABLE: expected serialization failure between INSERT and SELECT not encountered