From: | "Gokulakannan Somasundaram" <gokul007(at)gmail(dot)com> |
---|---|
To: | Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> |
Cc: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "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-10 11:13:23 |
Message-ID: | 9362e74e0801100313x27bf803aw76ac00c36db8862d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If possible can you send the data dump of these tables.
usuarios_temp , usuarios_indice ?
Thanks,
Gokul.
On Jan 10, 2008 4:00 PM, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote:
> 2008/1/8, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>:
> > 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.3server?
> >
> > 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
>
> Can someone reproduce or understand this? If so is there a chance to
> have it fixed in RC2?
>
> I see there is a post by Tom Lane in the hackers list about mergejoins
> but I don't understand if it is the same issue.
>
> Regards, Clodoaldo Pinto Neto
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | dformenton | 2008-01-10 11:14:48 | Re: Increase the number of concurrent connection |
Previous Message | Lars Heidieker | 2008-01-10 11:05:59 | Re: vacuum, dead rows, usual solutions didn't help |