On 2 July 2017 02:26:01 GMT+01:00, Daviramos Roussenq Fortunato
wrote:
>I am using pgAdmin for SQL test.
>
>
Are you using real hardware or is it vitual? Needs the query without explain
analyse the same time? Can you try it with psql (THE command line interface)?
Regards, Andreas
--
2ndQuad
I am using pgAdmin for SQL test.
Linux:
EXPLAIN ANALYZE select * from
"Seq Scan on lancamentosteste (cost=0.00..49289.74 rows=1883774 width=92)
(actual time=0.016..1194.453 rows=1883699 loops=1)"
"Total runtime: 2139.067 ms"
Windows:
"Seq Scan on lancamentosteste (cost=0.00..49288.67 rows=1883
On 01/07/2017 22:58, Tomas Vondra wrote:
> After that, you need to determine what is the bottleneck. Perhaps the
> resources are saturated by something else running on the system - other
> queries, maybe something else running next to PostgreSQL. Look at top
> and iotop while running the queries, a
Hello,
On 07/01/2017 10:39 PM, Daviramos Roussenq Fortunato wrote:
What tests could I do. Rigid Linux disk is much faster than Windows, I
should get a much better perfomace on this Linux. What test battery do
you recommend I do?
I'm not sure what you mean by "rigid disk" or "test battery",
What tests could I do. Rigid Linux disk is much faster than Windows, I
should get a much better perfomace on this Linux.
What test battery do you recommend I do?
2017-07-01 16:44 GMT-03:00 Andreas Kretschmer :
> On 1 July 2017 17:56:13 GMT+01:00, Daviramos Roussenq Fortunato <
> daviramo...@gma
On 1 July 2017 17:56:13 GMT+01:00, Daviramos Roussenq Fortunato
wrote:
>Debian:
>
>SELECT reltuples::numeric FROM pg_class WHERE oid =
>'mytable'::regclass;
>retuples=1883770
> --31ms
>
>SELECT pg_relation_filepath(oid), relpages FROM pg_class WHERE relname
>=
>'mytable';
>pg_relation_filepath=ba
Debian:
SELECT reltuples::numeric FROM pg_class WHERE oid = 'mytable'::regclass;
retuples=1883770
--31ms
SELECT pg_relation_filepath(oid), relpages FROM pg_class WHERE relname =
'mytable';
pg_relation_filepath=base/1003173/1204921
relpages=30452
--31ms
Windows
SELECT reltuples::numeric FROM p
