Re: Postgres DB Slowness
Ron <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <[email protected]> |
On 8/22/19 9:04 AM, [email protected] wrote: > > Hello Members, > > We have the below PostgreSQL database recently migrated from Oracle. > > The postgres DB parameters are *_attached_* here. > > # DB Version: 10 > > # OS Type: Linux > > # Total Memory (RAM): 30 GB > > #CPU > > nproc --all > > 2 > > There is huge slowness in the database now with any queries. > > *Oracle*- Select * from TABLENAME- in takes 0.009 milliseconds > > *PostgreSQL*- Same query takes more than 2 minutes. > Have you validated that the Postgres server has the same indexes? If so, did you ANALYZE all the tables? -- Angular momentum makes the world go 'round.