PostgreSQL Discussion - insertion becoming slow

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

insertion becoming slow

surabhi.ahuja

2005-09-27, 3:23 am

thanks for the help..
i removed a few indexes,
but i cant remove the primary key and uniqye key constraints ..whoch means that indexes will be made on these 2 attributes.

i have four tables, each having such 2 attributes, one which is the primary key and the other is the uniqu key.

and the insertion to these 4 tables is by means of 4 stored procedures (1 for each table).

These stored procedures are being called within a transaction ..which i begin from the application..

i noticed by putting timers that it is the "COMMIT TRANSACTION" statement to the database (after calling the 4 stored procedures) that is taking time.

but commit transaction is not slow each time, in fact it remains very small for a large number of installs ..then suddenly rises (becomes almost 8 times) and then falls again.

why such a behaviour?

thanks
regards
surabhi

Sponsored Links