Re: Postgres DB Slowness

On 8/22/19 9:35 AM, [email protected] wrote:
>
> *From:*Ron <[email protected]>
> *Sent:* Thursday, August 22, 2019 4:26 PM
> *To:* [email protected]
> *Subject:* Re: Postgres DB Slowness
>
> On 8/22/19 9:04 AM, [email protected] 
> <mailto:[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?
>
> Yes Ron, we migrated from Oracle as per same structure and indexes.
>
> I did the analyze for 2-3 tables now as per my SQL query I wrote and also 
> ran for one particular table below –
>
> VACUUM (FULL,ANALYZE) table_name.
>

What does the query plan for that query look like?

What's the table definition?

Is the hardware comparable?  (Might it be a SAN or VM issue?)

-- 
Angular momentum makes the world go 'round.