Ya this is because of ANALYZE.
now it's working fine.
Thanks for your support.
On Tue, Jun 25, 2019, 8:03 PM Adrian Klaver
wrote:
> On 6/25/19 7:24 AM, Pawan Sharma wrote:
> > In PostgreSQL logs it's showing select queries are running with duration
> > approx 37001.347ms
> >
>
> Is this norma
On 6/25/19 7:24 AM, Pawan Sharma wrote:
In PostgreSQL logs it's showing select queries are running with duration
approx 37001.347ms
Is this normal?
Did you run ANALYZE on the database after you restored it to the new
Postgres 11 cluster?
If not do so.
Then run the query in psql or someth
In PostgreSQL logs it's showing select queries are running with duration
approx 37001.347ms
On Tue, Jun 25, 2019, 7:44 PM Adrian Klaver
wrote:
> On 6/25/19 7:06 AM, Pawan Sharma wrote:
> > Can the app connect at all?
> > - yes connection between database and app B is successfully established.
>
On 6/25/19 7:06 AM, Pawan Sharma wrote:
Can the app connect at all?
- yes connection between database and app B is successfully established.
What is the app doing when it gets the error?
- from the app B we trying to delete some records in database.
Where is the error message appearing?
- message
Can the app connect at all?
- yes connection between database and app B is successfully established.
What is the app doing when it gets the error?
- from the app B we trying to delete some records in database.
Where is the error message appearing?
- messages are appearing in app server log.
Are the
On 6/25/19 6:49 AM, Pawan Sharma wrote:
Hi All,
I have upgarded my PostgreSQL database from 10 to 11 version using
pg_dump method.
That database is used by two apps.
1. A (most of the transaction are SELECT AND INSERT)
2. B ( most of the transaction UPDATE AND DELETE)
After the upgarde
