Updated:
I thought I'd put in my timing numbers on my computer (F16 on a Phenom II
> x6):
>
> Python3 port on python 3.2.1 w/ sqlite:
> * Ran 4429 tests in 528.327s
> * FAILED (errors=1, skipped=96, expected failures=2, unexpected
> successes=1) +
> Python3 port on python 2.7.2 w/ sqlite:
> * Ran 4490 tests in 487.212s
> * OK (skipped=82, expected failures=3)
> Django trunk (bitbucket mirror) on python 2.7.2 w/ sqlite:
> * Ran 4495 tests in 472.527s
> * OK (skipped=82, expected failures=3)
>
Python3 port on python 3.2.1 w/ psycopg2:
* Ran 4429 tests in 3102.890s
*FAILED (errors=3, skipped=75, expected failures=2, unexpected successes=1)
++
Python3 port on python 2.7.2 w/ psycopg2:
* Ran 4490 tests in 3086.170s
* OK (skipped=61, expected failures=3)
Django trunk (bitbucket mirror) on python 2.7.2 w/ psycopg2:
* Ran 4495 tests in 3316.408s
* OK (skipped=61, expected failures=3)
>
>
>
>
> All versions were grabbed around 11pm CST on 5 December 2011. The numbers
> were grabbed with a generally unused computer except for the tests (mostly
> just me browsing the web while I get bored waiting for tests to finish
> running). These are all single runs while I "putz" on my computer. I
> wouldn't count them for exacting numbers, but they should be good for
> finding order of magnitude problems. All tests are run w/ a command like
> "PYTHONPATH=..:$PYTHONPATH python ./runtests.py --settings=test_postgres"
> using the system packages from Fedora 16.
>
> Also, I had pypy 1.6 (from yum) installed. It would not run either trunk
> or the port. Not sure of the problem.
>
>
> +) ERROR: test_existing (regressiontests.templates.loaders.EggLoaderTest)
>
> A template can be loaded from an egg
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File
> "/home/joe/Projects/django2-3/django/tests/regressiontests/templates/loaders.py",
> line 88, in test_existing
>
> contents, template_name = egg_loader.load_template_source("y.html")
> File
> "/home/joe/Projects/django2-3/django/django/template/loaders/eggs.py", line
> 28, in load_template_source
> raise TemplateDoesNotExist(template_name)
> django.template.base.TemplateDoesNotExist: y.html
>
>
>
> ++) ERROR: test_recentactions_without_content_type
> (regressiontests.admin_views.tests.AdminViewStringPrimaryKeyTest)
> If a LogEntry is missing content_type it will not display it in span tag
> under the hyperlink.
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File
> "/home/joe/Projects/django2-3/django/django/db/backends/postgresql_psycopg2/base.py",
> line 54, in execute
> return self.cursor.execute(query, args)
> psycopg2.ProgrammingError: function upper(bytea) does not exist
> LINE 1: ...WHERE UPPER("django_content_type"."name"::text) = UPPER('\x4...
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File
> "/home/joe/Projects/django2-3/django/tests/regressiontests/admin_views/tests.py",
> line 1261, in test_recentactions_without_content_type
> logentry =
> LogEntry.objects.get(content_type__name__iexact=should_contain)
> File "/home/joe/Projects/django2-3/django/django/db/models/manager.py",
> line 131, in get
> return self.get_query_set().get(*args, **kwargs)
> File "/home/joe/Projects/django2-3/django/django/db/models/query.py",
> line 361, in get
> num = len(clone)
> File "/home/joe/Projects/django2-3/django/django/db/models/query.py",
> line 86, in __len__
> self._result_cache = list(self.iterator())
> File "/home/joe/Projects/django2-3/django/django/db/models/query.py",
> line 293, in iterator
> for row in compiler.results_iter():
> File
> "/home/joe/Projects/django2-3/django/django/db/models/sql/compiler.py",
> line 699, in results_iter
> for rows in self.execute_sql(MULTI):
> File
> "/home/joe/Projects/django2-3/django/django/db/models/sql/compiler.py",
> line 754, in execute_sql
> cursor.execute(sql, params)
> File
> "/home/joe/Projects/django2-3/django/django/db/backends/postgresql_psycopg2/base.py",
> line 60, in execute
> reraise(utils.DatabaseError, utils.DatabaseError(*e[1].args), e[2])
> File "/home/joe/Projects/django2-3/django/django/utils/py3.py", line
> 167, in reraise
> raise value.with_traceback(tb)
> File
> "/home/joe/Projects/django2-3/django/django/db/backends/postgresql_psycopg2/base.py",
> line 54, in execute
> return self.cursor.execute(query, args)
> django.db.utils.DatabaseError: function upper(bytea) does not exist
> LINE 1: ...WHERE UPPER("django_content_type"."name"::text) = UPPER('\x4...
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
>
>
> ======================================================================
> ERROR: test_recentactions_without_content_type
> (regressiontests.admin_views.tests.AdminViewStringPrimaryKeyTest)
> If a LogEntry is missing content_type it will not display it in span tag
> under the hyperlink.
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File
> "/home/joe/Projects/django2-3/django/django/db/backends/postgresql_psycopg2/base.py",
> line 54, in execute
> return self.cursor.execute(query, args)
> psycopg2.InternalError: current transaction is aborted, commands ignored
> until end of transaction block
>
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
> File
> "/home/joe/Projects/django2-3/django/tests/regressiontests/admin_views/tests.py",
> line 1228, in tearDown
> self.client.logout()
> File "/home/joe/Projects/django2-3/django/django/test/client.py", line
> 544, in logout
> session.delete(session_key=session_cookie.value)
> File
> "/home/joe/Projects/django2-3/django/django/contrib/sessions/backends/db.py",
> line 75, in delete
> Session.objects.get(session_key=session_key).delete()
> File "/home/joe/Projects/django2-3/django/django/db/models/manager.py",
> line 131, in get
> return self.get_query_set().get(*args, **kwargs)
> File "/home/joe/Projects/django2-3/django/django/db/models/query.py",
> line 361, in get
> num = len(clone)
> File "/home/joe/Projects/django2-3/django/django/db/models/query.py",
> line 86, in __len__
> self._result_cache = list(self.iterator())
> File "/home/joe/Projects/django2-3/django/django/db/models/query.py",
> line 293, in iterator
> for row in compiler.results_iter():
> File
> "/home/joe/Projects/django2-3/django/django/db/models/sql/compiler.py",
> line 699, in results_iter
> for rows in self.execute_sql(MULTI):
> File
> "/home/joe/Projects/django2-3/django/django/db/models/sql/compiler.py",
> line 754, in execute_sql
> cursor.execute(sql, params)
> File
> "/home/joe/Projects/django2-3/django/django/db/backends/postgresql_psycopg2/base.py",
> line 60, in execute
> reraise(utils.DatabaseError, utils.DatabaseError(*e[1].args), e[2])
> File "/home/joe/Projects/django2-3/django/django/utils/py3.py", line
> 167, in reraise
> raise value.with_traceback(tb)
> File
> "/home/joe/Projects/django2-3/django/django/db/backends/postgresql_psycopg2/base.py",
> line 54, in execute
> return self.cursor.execute(query, args)
> django.db.utils.DatabaseError: current transaction is aborted, commands
> ignored until end of transaction block
>
>
> ======================================================================
> ERROR: test_existing (regressiontests.templates.loaders.EggLoaderTest)
> A template can be loaded from an egg
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File
> "/home/joe/Projects/django2-3/django/tests/regressiontests/templates/loaders.py",
> line 88, in test_existing
> contents, template_name = egg_loader.load_template_source("y.html")
> File
> "/home/joe/Projects/django2-3/django/django/template/loaders/eggs.py", line
> 28, in load_template_source
> raise TemplateDoesNotExist(template_name)
> django.template.base.TemplateDoesNotExist: y.html
>
> PS: I too have a slow postgres even after I upped the shared_buffers and
> effective_cache_size while disabling fsync, and it is still pretty darn
> slow. (info from:
> http://www.revsys.com/writings/postgresql-performance.html) I'm testing
> w/ trunk to get a baseline w/ psycopg2. I'll admit I'm using a slow HDD,
> but I waited well over an hour.
>
> When I get back from work, I'll try psycopg2 and MySQL again tonight.
>
--
Joe & Anne Tennies
[email protected]
--
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-developers?hl=en.
