Optimising inside transactions - Mailing list pgsql-novice

From John Taylor
Subject Optimising inside transactions
Date
Msg-id 02061216072607.03223@splash.hq.jtresponse.co.uk
Whole thread Raw
Responses Re: Optimising inside transactions
Re: Optimising inside transactions
List pgsql-novice
Hi,

I'm running a transaction with about 1600 INSERTs.
Each INSERT involves a subselect.

I've noticed that if one of the INSERTs fails, the remaining INSERTs run in about
1/2 the time expected.

Is postgresql optimising the inserts, knowing that it will rollback at the end ?

If not, why do the queries run faster after the failure ?

Thanks
JohnT

pgsql-novice by date:

Previous
From: John Taylor
Date:
Subject: How efficient are Views
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: How efficient are Views