Re: Insert into partition table hangs - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: Insert into partition table hangs
Date
Msg-id e4k59r$2i33$1@news.hub.org
Whole thread Raw
List pgsql-general
"Nik" <XLPizza@gmail.com> wrote
> I have an application that executes an INSERT statement every second or
> two. In my old design this data was inserted into one table. However, I
> changed the design to have one table with multiple partitions. Now when
> I run the application it runs for some random amount of time (random
> number of INSERTs) and then it gets stuck at the INSERT query and it
> never finishes (at least not in some reasonable time - aka few hours).
> If I restart the application it continues inserting the data normally
> for a while before getting stuck again.
>

Do you do INSERT concurrently? Can you post a self-contained example to
reproduce it?

Regards,
Qingqing



pgsql-general by date:

Previous
From: Nis Jorgensen
Date:
Subject: Re: invalid byte sequence for encoding error
Next
From: "Oliver A. Rojo"
Date:
Subject: Re: invalid byte sequence for encoding error