Postgres Pro
Downloads
Home   >   mailing lists

Reporting query failing - Mailing list pgsql-performance

From aup20
Subject Reporting query failing
Date
Msg-id 1369489584936-5756840.post@n5.nabble.com
Whole thread Raw
Responses Re: Reporting query failing
List pgsql-performance
Tree view 
I am using postgresql  9.2, and we are getting error like -
System.Data.EntityException: The underlying provider failed on Open. --->
Devart.Data.PostgreSql.PgSqlException: Stream already closed!!!.   I have
turned the autovacuum on but my reporting query is failing.  When the manual
full autovacuum is performed along with analyse the reporting query works.
Please let me know how to deal with this situation.

Thank you
A.



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Reporting-query-failing-tp5756840.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Very slow inner join query Unacceptable latency.
Next
From: Tomas Vondra
Date:
Subject: Re: Reporting query failing