Re: MySQL and PostgreSQL speed compare
От | Gordan Bobic |
---|---|
Тема | Re: MySQL and PostgreSQL speed compare |
Дата | |
Msg-id | 001101c071ab$533e1de0$8000000a@localdomain обсуждение исходный текст |
Ответ на | MySQL and PostgreSQL speed compare ("Jarmo Paavilainen" <netletter@comder.com>) |
Ответы |
Re: MySQL and PostgreSQL speed compare
Re: MySQL and PostgreSQL speed compare |
Список | pgsql-general |
> * Adam Lang <aalang@rutgersinsurance.com> [001229 05:47] wrote: > > But isn't it recommended to run the server with fsync? If so, you shouldn't > > disable it on a benchmark then. > > Actually, if he ran Postgresql with WAL enabled, fsync shouldn't > make much of a difference. What's WAL? Are you referring to autocommit? I will admit that autocomit already improves performance so much that fsync() isn't going to matter that much, but it will still make a noticeable improvement. It certainly did on my system (~20%). FWIW, disabling autocommint, and introducing the overhead of doing a select for checking before EVERY INSERT and UPDATE, made an improvement of about 2-3 times on my application... But, different applications require different things, so... YMMV... Regards. Gordan
В списке pgsql-general по дате отправления: