Hi every one,
I've tried to reindex one of my customer's table to gain some disk space.
I had to stop after 90 m cpu...
I've then pg_dump'ed the database and recreate an other both on 7.3.4 and
7.4b
Both are still running after more than 30 minutes of CPU (100% cpu taken)
creating the levt_lu_ligne_evt_key.
Disks don't do anything, just cpu.
Here are the info I have
test=# \d ligneevt
Table "public.ligne_evt"
Column | Type | Modifiers
-----------------+--------------------------+-----------------------------------
-------------
levt_cod | integer | not null default nextval('seq_levt
_cod'::text)
levt_tevt_cod | integer | not null
levt_date | timestamp with time zone | not null
levt_type_per1 | integer | not null
levt_perso_cod1 | integer | not null
levt_type_per2 | integer |
levt_perso_cod2 | integer |
levt_texte | text |
levt_lu | character varying(2) | default 'N'
levt_visible | character varying(2) |
levt_attaquant | integer |
levt_cible | integer |
Indexes: ligne_evt_pkey primary key btree (levt_cod),
levt_attaquant_ligne_evt_key btree (levt_attaquant),
levt_cible_ligne_evt_key btree (levt_cible),
levt_lu_ligne_evt_key btree (levt_lu),
levt_visible_ligne_evt_key btree (levt_visible),
ligne_evt_levt_cod_key btree (levt_cod),
ligne_evt_levt_date_key btree (levt_date),
ligne_evt_levt_perso_cod1_key btree (levt_perso_cod1),
ligne_evt_levt_perso_cod2_key btree (levt_perso_cod2),
ligne_evt_levt_tevt_cod_key btree (levt_tevt_cod),
ligne_evt_levt_type_per1_key btree (levt_type_per1),
ligne_evt_levt_type_per2_key btree (levt_type_per2)
Triggers: RI_ConstraintTrigger_5453038
test=# SELECT count(*) from ligne_evt ;
count
--------
230670
(1 row)
test=# SELECT levt_lu,count(*) from ligne_evt group by levt_lu;
levt_lu | count
---------+--------
N | 49435
O | 181242
(2 rows)
Can some one help me?
Regards
--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: [EMAIL PROTECTED]
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
