Hi, I have a django-based web application (django 1.1.0) and I encounter some db related issues. (i am using python_psycopg2 and PostgreSQL 8.4)
Every connection psycopg2 establishes, it performs the following statements: Feb 27 04:02:04 gallus postgres[28534]: [6756-1] user=postgres,db=markafoni LOG: statement: SET DATESTYLE TO 'ISO' Feb 27 04:02:04 gallus postgres[28534]: [6757-1] user=postgres,db=markafoni LOG: duration: 0.115 ms Feb 27 04:02:04 gallus postgres[28534]: [6758-1] user=postgres,db=markafoni LOG: statement: SHOW client_encoding Feb 27 04:02:04 gallus postgres[28534]: [6759-1] user=postgres,db=markafoni LOG: duration: 0.089 ms Feb 27 04:02:04 gallus postgres[28534]: [6760-1] user=postgres,db=markafoni LOG: statement: SHOW default_transaction_isolation Feb 27 04:02:04 gallus postgres[28534]: [6761-1] user=postgres,db=markafoni LOG: duration: 0.079 ms Feb 27 04:02:04 gallus postgres[28534]: [6762-1] user=postgres,db=markafoni LOG: statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ COMMITTED Feb 27 04:02:04 gallus postgres[28534]: [6763-1] user=postgres,db=markafoni LOG: duration: 0.076 ms Feb 27 04:02:04 gallus postgres[28534]: [6764-1] user=postgres,db=markafoni LOG: statement: SET TIME ZONE E'Europe/ Istanbul' Feb 27 04:02:04 gallus postgres[28534]: [6765-1] user=postgres,db=markafoni LOG: duration: 0.058 ms which causes a little bit overhead for every transaction. But those transactions are being made hundred times per second so is a huge dead weight. Is there a way to disable these transactions from django (some db related configurations in settings file, etc..) or do i have to write my own db backend? Thanks. -- Özgür Vatansever -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
