Re: 8.4.1 ubuntu karmic slow createdb

Поиск
Список
Период
Сортировка
От Nikolas Everett
Тема Re: 8.4.1 ubuntu karmic slow createdb
Дата
Msg-id d4e11e980912111339q355f9fb2rf444f47a208b5b1e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.4.1 ubuntu karmic slow createdb  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: 8.4.1 ubuntu karmic slow createdb  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: 8.4.1 ubuntu karmic slow createdb  (Scott Mead <scott.lists@enterprisedb.com>)
Список pgsql-performance


On Fri, Dec 11, 2009 at 3:50 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On Fri, 2009-12-11 at 15:43 -0500, Nikolas Everett wrote:
> Turning fsync off on a dev database is a bad idea?  Sure you might
> kill it and have to start over, but thats kind of the point in a dev
> database.

My experience is that bad dev practices turn into bad production
practices, whether intentionally or not.

Fair enough.  I'm of the opinion that developers need to have their unit tests run fast.  If they aren't fast then your just not going to test as much as you should.  If your unit tests *have* to createdb then you have to do whatever you have to do to get it fast.  It'd probably be better if unit tests don't create databases or alter tables at all though.

Regardless of what is going on on your dev box you really should leave fsync on on your continuous integration, integration test, and QA machines.  They're what your really modeling your production on anyway.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: 8.4.1 ubuntu karmic slow createdb
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: 8.4.1 ubuntu karmic slow createdb