Re: Improve MMO Game Performance
| От | Arvind Singh |
|---|---|
| Тема | Re: Improve MMO Game Performance |
| Дата | |
| Msg-id | BLU164-W56D11F42972772B9374BFFCA750@phx.gbl обсуждение исходный текст |
| Ответ на | Re: Improve MMO Game Performance (Alvaro Herrera <alvherre@2ndquadrant.com>) |
| Ответы |
Re: Improve MMO Game Performance
|
| Список | pgsql-general |
ok,
thanks i will look into walbuffers
asynchronous_commit=off is a doubt for responsive environment (pg manual). for ex.
would it help if,
a game player , has to perform next move on basis of his/her previous move plus other players move.
all is sent to table and for each player a particular set is retrieved with a minimalistic data portfolio
thanks i will look into walbuffers
asynchronous_commit=off is a doubt for responsive environment (pg manual). for ex.
would it help if,
a game player , has to perform next move on basis of his/her previous move plus other players move.
all is sent to table and for each player a particular set is retrieved with a minimalistic data portfolio
> Date: Thu, 18 Oct 2012 11:24:00 -0300
> From: alvherre@2ndquadrant.com
> To: laurenz.albe@wien.gv.at
> CC: arvindps@hotmail.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Improve MMO Game Performance
>
> 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: alvherre@2ndquadrant.com
> To: laurenz.albe@wien.gv.at
> CC: arvindps@hotmail.com; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Improve MMO Game Performance
>
> 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
В списке pgsql-general по дате отправления: