Bonjour,

Je travaille sur une base 8.1 sous Red-Hat 4.

Je fais un Delete d'un enregistrement au travers d'une interface et cette action prend environ 2 MINUTES.

Dans le fichier de log, je vois ceci :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
2009-12-08 17:10:59 CSTLOG:  duration: 123897.495 ms  statement: SELECT * , CTID, OID FROM geo.Ptg_pers  where ctid = currtid2('"geo"."ptg_pers"', '(252119, 14)') and oid  = 25790957
2009-12-08 17:12:38 CSTLOG:  duration: 430.547 ms  statement: SELECT att.*, def.*, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS defval, CASE WHEN attndims > 0 THEN 1 ELSE 0 END AS isarray, format_type(ty.oid,NULL) AS typname, tn.nspname as typnspname, et.typname as elemtypname,
          cl.relname, na.nspname, att.attstattarget, description, cs.relname AS sername, ns.nspname AS serschema,
          (SELECT count(1) FROM pg_type t2 WHERE t2.typname=ty.typname) > 1 AS isdup, indkey,
          EXISTS(SELECT 1 FROM  pg_constraint WHERE conrelid=att.attrelid AND contype='f' AND att.attnum=ANY(conkey)) As isfk
          FROM pg_attribute att
          JOIN pg_type ty ON ty.oid=atttypid
          JOIN pg_namespace tn ON tn.oid=ty.typnamespace
          JOIN pg_class cl ON cl.oid=attrelid
          JOIN pg_namespace na ON na.oid=cl.relnamespace
          LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem
          LEFT OUTER JOIN pg_attrdef def ON adrelid=attrelid AND adnum=attnum
          LEFT OUTER JOIN pg_description des ON des.objoid=attrelid AND des.objsubid=attnum
          LEFT OUTER JOIN (pg_depend JOIN pg_class cs ON objid=cs.oid AND cs.relkind='S') ON refobjid=attrelid AND refobjsubid=attnum
          LEFT OUTER JOIN pg_namespace ns ON ns.oid=cs.relnamespace
          LEFT OUTER JOIN pg_index pi ON pi.indrelid=attrelid AND indisprimary
         WHERE attrelid = 20964::oid
           AND attnum > 0
           AND attisdropped IS FALSE
         ORDER BY attnum
Est-ce que cela correspond à mon Delete ?

Y-a-t'il un problème ?

Merci de votre aide.