Re: Postgres DB Slowness

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres DB Slowness
Date: 2019-08-23 11:35:49
Message-ID: 1566560149796-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi
Could you explain us how you test

Oracle - Select * from TABLENAME-
in takes 0.009 milliseconds

Is it with oracle sql developer ?
How long does it take with sql*plus ?

Note that sql developer only display first 50 or 100 rows ,
You should use the « count rows » button to get a better duration estimate.

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bikram Majumdar 2019-08-23 20:10:20 Re: Question on pgwatch
Previous Message Juan José Santamaría Flecha 2019-08-23 11:08:24 Re: Postgres DB Slowness