What secret resipy of PostgreSQL (insert more faster than delete)?

From: henryJack <henryJack85(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: What secret resipy of PostgreSQL (insert more faster than delete)?
Date: 2007-07-07 14:27:20
Message-ID: 11478978.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


What secret resipy of PostgreSQL (insert more faster than delete)?

I doing an investigation on PostgreSQL, I figure out PostgreSQL powerful in
inserting data into the database.

We normally, expect that insert more slow than select and delete queries
because database have to create a row then set the data one by one into the
database (in between check is it the row correct to inside?)....

Delete just delete the whole row that checked ones.

Quite curious on this....

Any new technology implemented?

Thank you

Peace!!!!

-Henry Jack:computer-user:
--
View this message in context: http://www.nabble.com/What-secret-resipy-of-PostgreSQL-%28insert-more-faster-than-delete%29--tf4040603.html#a11478978
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-07-07 15:44:48 Re: Unable to get postgres running after long time no vacuum
Previous Message Andreas 'ads' Scherbaum 2007-07-07 12:51:43 Re: Problem with autovacuum and pg_autovacuum