Re: Postgres DB Slowness - Mailing list pgsql-admin

From Jeff Janes
Subject Re: Postgres DB Slowness
Date
Msg-id CAMkU=1wAfD4JZMudvF95SxAoKiyHfJb5DSsk-BbrfsbJAV6W_A@mail.gmail.com
Whole thread Raw
In response to Postgres DB Slowness  (<soumik.bhattacharjee@kpn.com>)
List pgsql-admin
On Thu, Aug 22, 2019 at 10:05 AM <soumik.bhattacharjee@kpn.com> wrote:


There is huge slowness in the database now with any queries.

 

Oracle - Select * from TABLENAME- in takes  0.009 milliseconds


Oracle is not returning 10 million rows in 0.009 milliseconds.

Perhaps whatever you are doing in Oracle is the equivalent of "EXPLAIN" without ANALYZE in PostgreSQL, or to PREPARE in PostgreSQL.  It just plans the query without executing it.

Cheers,

Jeff

pgsql-admin by date:

Previous
From: "Jehan-Guillaume (ioguix) de Rorthais"
Date:
Subject: Re: Postgres DB Slowness
Next
From:
Date:
Subject: RE: Postgres DB Slowness