| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | soumik(dot)bhattacharjee(at)kpn(dot)com |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Postgres DB Slowness |
| Date: | 2019-08-22 20:57:50 |
| Message-ID: | CAMkU=1wAfD4JZMudvF95SxAoKiyHfJb5DSsk-BbrfsbJAV6W_A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Aug 22, 2019 at 10:05 AM <soumik(dot)bhattacharjee(at)kpn(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bikram MAJUMDAR | 2019-08-22 21:50:08 | RE: Question on pgwatch |
| Previous Message | Jehan-Guillaume (ioguix) de Rorthais | 2019-08-22 20:30:28 | Re: Postgres DB Slowness |