On 8/22/19 9:04 AM, soumik(dot)bhattacharjee(at)kpn(dot)com 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.