Re: Optimise PostgreSQL for fast testing

Поиск
Список
Период
Сортировка
Искать
От
Dmytrii Nagirniak
Тема
Re: Optimise PostgreSQL for fast testing
Дата
Msg-id
BCC7B5B1-3257-45DE-92B1-8A820A619D00@gmail.com
Ответ на
Список
Дерево обсуждения
Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Adrian Klaver <adrian.klaver@gmail.com>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Adrian Klaver <adrian.klaver@gmail.com>
Re: Optimise PostgreSQL for fast testing Alban Hertroys <haramrae@gmail.com>
Re: Optimise PostgreSQL for fast testing Jan Kesten <jan@dafuer.de>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Marti Raudsepp <marti@juffo.org>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Pavel Stehule <pavel.stehule@gmail.com>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Pavel Stehule <pavel.stehule@gmail.com>
Re: Optimise PostgreSQL for fast testing Simon Riggs <simon@2ndQuadrant.com>
Re: Optimise PostgreSQL for fast testing Jack Christensen <jackc@hylesanderson.edu>
Re: Optimise PostgreSQL for fast testing David Salisbury <salisbury@globe.gov>
Re: Optimise PostgreSQL for fast testing Scott Marlowe <scott.marlowe@gmail.com>
Re: Optimise PostgreSQL for fast testing Simon Riggs <simon@2ndQuadrant.com>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Scott Marlowe <scott.marlowe@gmail.com>
Re: Optimise PostgreSQL for fast testing Scott Marlowe <scott.marlowe@gmail.com>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Greg Smith <greg@2ndQuadrant.com>
Re: Optimise PostgreSQL for fast testing Simon Riggs <simon@2ndQuadrant.com>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Dmytrii Nagirniak <dnagir@gmail.com>
Re: Optimise PostgreSQL for fast testing Simon Riggs <simon@2ndQuadrant.com>
On 24/02/2012, at 5:15 AM, Simon Riggs wrote:

Now all you have to do is parallelise the tests and everything can
work 10 times quicker and it would be much faster than the time SQLite
produced.

So using PostgreSQL for testing would be both quicker and more
accurate, if you set the tests up right.

That is certainly true. And there are number of techniques to make tests faster.
But that is outside of the scope of this thread I believe.

I only want to make it run locally (don't care about CI yet) faster.
So far I could get the most out of with fsync=off (which is ~15% improvement).


В списке pgsql-general по дате отправления
От: Dmytrii Nagirniak
Дата:
От: Greg Smith
Дата:
FAQ