| From: | Dann Corbit <DCorbit(at)connx(dot)com> |
|---|---|
| To: | 'zach cruise' <zachc1980(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: what happens to postmaster? |
| Date: | 2010-06-22 18:21:01 |
| Message-ID: | 87F42982BF2B434F831FCEF4C45FC33E0C2006A5@EXCHANGE.corporate.connx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of zach cruise
> Sent: Tuesday, June 22, 2010 11:09 AM
> To: pgsql-general(at)postgresql(dot)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 PostgreSQL is 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2010-06-22 18:21:23 | Re: what happens to postmaster? |
| Previous Message | Juba, Salahaldin I. | 2010-06-22 18:13:30 | SQL error: could not connect to database |