On Wed, Jul 9, 2014 at 1:25 PM, M Tarkeshwar Rao
wrote:
>
> I am sharing the table structure. When we removed the unique index it is
> working fine.
> And when created normal index(not unique) it is working fine.
>
> After removing unique index we tried to recreate it but it is giving
> followin
-general@postgresql.org
Subject: [GENERAL] Insert query hangs
Hi all,
We have a table in a database DB1 with name Test. We imported this database
from another machine.
When I fire insert statement it is going in the hang state.
Then I created another table with same structure and with same data
Hi Greg,
Sending few discussions with one of the postgres person. You will understand
what is the problem.
Regards
Tarkeshwar
Can this be of help [1]?
[1]
http://www.postgresql.org/docs/9.2/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY
Regards,
Niklas
__
On Wed, Jul 9, 2014 at 11:34 AM, M Tarkeshwar Rao
wrote:
>
> We analysed one more thing when we removed the unique index from the table it
> is working fine.
> Is there any issue in indexing?
>
> Is there any option to repair the table or its indexing?
REINDEX is useful for indexes.
>From the s
...@postgresql.org; pgsql-hack...@postgresql.org;
pgsql-general@postgresql.org
Subject: [GENERAL] Insert query hangs
Hi all,
We have a table in a database DB1 with name Test. We imported this database
from another machine.
When I fire insert statement it is going in the hang state.
Then I created
Hi all,
We have a table in a database DB1 with name Test. We imported this database
from another machine.
When I fire insert statement it is going in the hang state.
Then I created another table with same structure and with same data within it
as in table Test.
Then I fired the insert statemen
On Thu, Jun 19, 2014 at 1:59 PM, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
> Hi,
>
> Insert query hangs what could be the reason. Is there any way to find out?
> Any timeout feature there with query which can be set at client or server
> end?
>
>
It might be due to concurrent primar
Hi,
Insert query hangs what could be the reason. Is there any way to find out?
Any timeout feature there with query which can be set at client or server end?
Regards
Tarkeshwar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://ww
