>From http://www.postgresql.org/docs/9.4/static/sql-createtable.html
UNLOGGED
If specified, the table is created as an unlogged table. Data
written to unlogged tables is not written to the write-ahead log (see
Chapter 29), which makes them considerably faster than ordinary
tables. However, they are not crash-safe: an unlogged table is
automatically truncated after a crash or unclean shutdown. The
contents of an unlogged table are also not replicated to standby
servers. Any indexes created on an unlogged table are automatically
unlogged as well.
So, when PG says it's "considerably faster"... well, they're not known
for overstatement :)
Personally, I'd love to see it as an option [I'm sure I opened a
ticket about it somewhere] but last I tried to implement it the ORM
methods that looked promising were, in fact, misnamed.
I'm sure now that Andrew has significantly cleaned up the table
generation code, it should be feasible to add this option.
As far as "todo list"... there isn't one. Either someone stands up
and submits a PR, or they don't... if you don't, don't expect someone
else to. :)
--
Curtis
On 13 July 2015 at 02:07, Federico Capoano <federico.capo...@gmail.com> wrote:
> I just ran into this ticket:
> https://code.djangoproject.com/ticket/24306
>
> I found myself in a situation where it would be really useful.
>
> Two questions:
>
> has anybody verified that UNLOGGED tables really perform faster when running
> tests with Postgres?
> is this feature on the TODO list for the next release? If yest what needs to
> be done in ordere to help out?
>
> Thanks
> Federico
>
> --
> 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/35f7d80b-7c79-4caf-be0f-7b9c1796fcb2%40googlegroups.com.
> 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/CAG_XiSAqy5ytbhZJLVKozoNXz4QAjkU%3DXFzWrwHy6Xa9db4T0A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
