> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of zach cruise
> Sent: Tuesday, June 22, 2010 11:09 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] what happens to postmaster?
>
> ...when i am importing a table (from oracle, or updating it), and a
> user queries that same table?
>
> is it ok to be concerned about corruption etc.
>
> using 8.1.
This is a relational database. All those things are handled automatically. The whole idea of a multi-user DBMS like
PostgreSQLis that you can have concurrent access.
PostgreSQL uses MVCC. Here is an article that explains how it works. If you read it perhaps you will feel more
comfortable:
http://en.wikipedia.org/wiki/Multiversion_concurrency_control