Plpgsql Insert Performance Test

Sometimes you need to execute some SQL scripts, with logical control statements, and do not want to use the high-level language C #, Java and the like, you can directly use Plpgsql, similar to Oracle's Plsql.

1Do language'Plpgsql' $$2 Declare3Iinteger;4 begin5   --raise notice ' Hello World ';6   7    forIinch 5..100000Loop8     Insert  intoDbo.a_org_type (id, des)9     ValuesI'shang Hai Xu Hui');Ten   EndLoop; One End; A $$ -  - --Select COUNT (*) from Dbo.a_org_type; the --Delete from Dbo.a_org_type where ID > 4;

Time-consuming = 1.5 seconds

On Windows7 x64

Intel Pentium CPU B950 2.1GHz

Plpgsql Insert Performance Test