Re: Postgres DB Slowness
Jeff Janes <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <CAMkU=1wAfD4JZMudvF95SxAoKiyHfJb5DSsk-BbrfsbJAV6W_A@mail.gmail.com> |
On Thu, Aug 22, 2019 at 10:05 AM <[email protected]> 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 >