Re: ExclusiveLock on PostgreSQL - Fabio Mendonça

From: Fabio Oliveira De Mendonca <fabiomedonca(at)brq(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: "ktm(at)it(dot)is(dot)rice(dot)edu" <ktm(at)it(dot)is(dot)rice(dot)edu>, "gsstark(at)mit(dot)edu" <gsstark(at)mit(dot)edu>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "fabio(dot)mendonca(dot)arq(at)gmail(dot)com" <fabio(dot)mendonca(dot)arq(at)gmail(dot)com>
Subject: Re: ExclusiveLock on PostgreSQL - Fabio Mendonça
Date: 2015-10-30 13:20:30
Message-ID: BLUPR80MB126711458B2BC4A823A2924FD82F0@BLUPR80MB1267.lamprd80.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Thanks Robert.

I read the material link and did help me to take a new decision

thank you.
att.

Fabio Mendonça

________________________________________
De: Robert Haas <robertmhaas(at)gmail(dot)com>
Enviado: sexta-feira, 30 de outubro de 2015 07:49
Para: Fabio Oliveira De Mendonca
Cc: ktm(at)it(dot)is(dot)rice(dot)edu; gsstark(at)mit(dot)edu; pgsql-hackers(at)postgresql(dot)org; fabio(dot)mendonca(dot)arq(at)gmail(dot)com
Assunto: Re: [HACKERS] ExclusiveLock on PostgreSQL - Fabio Mendonça

On Wed, Oct 28, 2015 at 5:59 PM, Fabio Oliveira De Mendonca
<fabiomedonca(at)brq(dot)com> wrote:
> I 've a process with 600.000 rows, for insert on table "A" with 130 columns
> and I'm received the "Exclusivelock" error message, making lost some
> rows during transaction. The insert of transaction occurs on each 2 min.
> and for each 1 min, a second process read the table "A" (with Join Table "C"
> using PK ) to make a insert on a table ("B") . Well , I did think create
> a partitions on table "A", but I don't believe get a correcting in the
> problem ( "Exclusivelock" ).

This isn't really the right mailing list for this question.

You might find https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
helpful, or you can ask at
http://www.postgresql.org/list/pgsql-general/

You should also read
https://wiki.postgresql.org/wiki/Guide_to_reporting_problems --
because this report does not contain enough information for someone to
answer your question. In particular, including the exact text of any
commands you executed and any error or other messages the system
generated would be helpful.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-10-30 13:26:45 Re: Patch: Implement failover on libpq connect level.
Previous Message Robert Haas 2015-10-30 13:04:29 Re: [HACKERS] Replication slots and isolation levels