Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres DB Slowness - Mailing list pgsql-admin

From legrand legrand
Subject Re: Postgres DB Slowness
Date
Msg-id 1566560149796-0.post@n3.nabble.com
Whole thread Raw
In response to Postgres DB Slowness  (<soumik.bhattacharjee@kpn.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Juan José Santamaría Flecha
Date:
Subject: Re: Postgres DB Slowness
Next
From: Luca Ferrari
Date:
Subject: Re: Permission for not Django app to do Write and Read