That's also a viable alternative, although it also mention unlogged tables, which are not supported by django.
We could list the quick hint with config sample, a link to pg non durable options page and a warning that UNLOGGED tables are not supported yet. What do you think about this? BTW has anyone had the time to try unlogged tables with their test suite to see if it gave them any improvements? I am quite surprised i didn't even get a 5-10% improvement out of the promised 10-17%. Federico Wouldn't it be enough to just have link to the correct PostgreSQL site: http://www.postgresql.org/docs/current/static/non-durability.html And then some text with "if you want to run your tests on postgresql please see the docs around non durable postgres" 2015-07-13 18:46 GMT+02:00 Federico Capoano <federico.capo...@gmail.com>: > Sure, i've just done something similar for this project: > > http://nodeshot.readthedocs.org/en/latest/topics/install_development.html#how-to-setup-the-test-environment > > The *keepdb* option allows to avoid recreating the test database at each > run, hence saving precious time. > > If you want to speed up tests even more, tweak your local postgresql > configuration by setting these values: > > # /etc/postgresql/9.1/main/postgresql.conf > # only for development! > fsync = off > synchronous_commit = off > full_page_writes = off > > > We just have to make sure people actually find this information via search > engines. > > The best thing would be to have a subsection called "How to speed up tests > with Postgres" or something similar. > > What do you think? > > Federico > > > > On Monday, July 13, 2015 at 5:54:08 PM UTC+2, Aymeric Augustin wrote: >> >> Hello Federico, >> >> 2015-07-13 16:26 GMT+02:00 Federico Capoano <federico...@gmail.com>: >> >>> While these are the winners: >>> >>> - fsync = off >>> - synchronous_commit = off >>> - full_page_writes = off >>> >>> Would you like to submit a patch to docs/ref/databases.txt, in the >> "PostgreSQL >> notes" section, explaining this configuration? >> >> I'm sure it would help many people run their tests faster on PostgreSQL. >> It would >> also counter the trend to run tests on SQLite "because it's faster" — it >> isn't. >> >> -- >> Aymeric. >> > -- > You received this message because you are subscribed to the Google Groups > "Django developers (Contributions to Django itself)" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com. > To post to this group, send email to django-developers@googlegroups.com. > Visit this group at http://groups.google.com/group/django-developers. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-developers/7c3c1b6c-68f5-4cf0-b2db-d5fa58a6930d%40googlegroups.com > <https://groups.google.com/d/msgid/django-developers/7c3c1b6c-68f5-4cf0-b2db-d5fa58a6930d%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to a topic in the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-developers/IkRgMxTTzPQ/unsubscribe. To unsubscribe from this group and all its topics, send an email to django-developers+unsubscr...@googlegroups.com. To post to this group, send email to django-developers@googlegroups.com. Visit this group at http://groups.google.com/group/django-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAPDLAU7bYbeYb7pRgmqTR--zUrdU0fJyB5mHPWHoGEgawbB-MA%40mail.gmail.com <https://groups.google.com/d/msgid/django-developers/CAPDLAU7bYbeYb7pRgmqTR--zUrdU0fJyB5mHPWHoGEgawbB-MA%40mail.gmail.com?utm_medium=email&utm_source=footer> . For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To post to this group, send email to django-developers@googlegroups.com. Visit this group at http://groups.google.com/group/django-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAERYH6XLR6idaHzYOuuJ65iR%3DqXw8FsTvCyj-8OfjSeMAmS5qA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
