Didn't anyone experience this problem? On Mon, Mar 1, 2010 at 4:43 PM, ozgur vatansever <ozgu...@gmail.com> wrote: > 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 > >
-- Ö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.
