From: | Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> |
---|---|
To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, "PostgreSQL General ML" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Performance problem. Could it be related to 8.3-beta4? |
Date: | 2008-01-08 09:48:58 |
Message-ID: | a595de7a0801080148y2f18f6b8x2c7e5a2e2cc3a7dc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2008/1/8, Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
> Clodoaldo escribió:
>
> 8.2:
>
> > Trigger for constraint datas: time=14231.240 calls=880691
> > Total runtime: 356862.302 ms
> > (12 rows)
> >
> > Time: 357750.531 ms
>
> 8.3:
>
> > Trigger for constraint datas: time=33179.197 calls=877895
> > Total runtime: 9546878.520 ms
> > (13 rows)
>
> So what's this constraint and why is it taking longer on the 8.3 server?
fahstats=> \d+ usuarios
Table "public.usuarios"
Column | Type | Modifiers | Description
---------+---------+-----------+-------------
usuario | integer | not null |
data | integer | not null |
wus | integer | not null |
pontos | real | not null |
Indexes:
"ndx_usuarios_data" btree (data) CLUSTER
"ndx_usuarios_usuario" btree (usuario)
Foreign-key constraints:
"datas" FOREIGN KEY (data) REFERENCES datas(data_serial) ON UPDATE
RESTRICT ON DELETE RESTRICT
Has OIDs: no
fahstats=> \d+ datas
Table "public.datas"
Column | Type |
Modifiers | Description
-------------+--------------------------+-------------------------------------------------------------+-------------
data_serial | integer | not null default
nextval('datas_data_serial_seq'::regclass) |
data | timestamp with time zone | not null
|
have_data | boolean | not null default true
|
Indexes:
"pk_data" PRIMARY KEY, btree (data)
"data_ndx" UNIQUE, btree (data_serial) CLUSTER
Has OIDs: no
Regards, Clodoaldo Pinto Neto
From | Date | Subject | |
---|---|---|---|
Next Message | Pedro Briones García | 2008-01-08 11:18:43 | Problema al cargar polígonos |
Previous Message | Ivan Sergio Borgonovo | 2008-01-08 09:31:56 | firewall and resource management was: Memory on 32bit machine |