Hello,
I want to see all rows of my table with this sql query on pgadmin4 v1.4 on my PC with windows 7.
Select * from public.fil
this table as 930000 rows, the table size is 79Mo
the ddl is
CREATE TABLE public.fil
(
identifiant integer NOT NULL,
numero integer NOT NULL,
numeroregroupement integer,
id_tube integer,
statut character(3) COLLATE pg_catalog."default",
numero_tete_cable smallint,
attribute1 character varying(25) COLLATE pg_catalog."default",
attribute2 character varying(25) COLLATE pg_catalog."default",
attribute3 character varying(25) COLLATE pg_catalog."default",
connexion_origine character varying(5) COLLATE pg_catalog."default",
connexion_extremite character varying(5) COLLATE pg_catalog."default",
CONSTRAINT id_fil PRIMARY KEY (identifiant)
USING INDEX TABLESPACE idx_1,
CONSTRAINT fk_id_tube FOREIGN KEY (id_tube)
REFERENCES public.tube (identifiant) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE CASCADE
)
After a long time pgadmin4 crash without message or log
This sql query work fine with pgadmin3 1.22.1 on the same PC but this is very slow 52s
Regards
Francis