| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Edson Vilhena de Carvalho <edson_jvc(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: backend process |
| Date: | 2005-03-23 16:23:28 |
| Message-ID: | 1111595008.26897.1482.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote:
> I'm a new user of postgreSQL
>
> I was loking at the documentation and testing some
> things and I make:
>
> select * from pg_stat_database;
>
> pg_stat_database is writen on the table of page 317,
> one os the outputs is numbackends that is the number
> of
> active backend server processes. I would like to know
> what is a active backend server processes.
In PostgreSQL every connection spawns a new backend that operates on the
database semi-independently, cooperating with the other backends by
means of shared memory.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-03-23 16:28:34 | Re: Simple query takes a long time on win2K |
| Previous Message | Joshua D. Drake | 2005-03-23 16:22:36 | Re: I'm OWNER of the db but I get `permission denied` when |