Thread: backend process

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.

Tank very much
Edson Carvalho

__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/

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.

Scott Marlowe <smarlowe@g2switchworks.com> writes:
> On Wed, 2005-03-23 at 10:11, Edson Vilhena de Carvalho wrote:
>> 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.

See
http://www.postgresql.org/docs/8.0/static/tutorial-arch.html
http://www.postgresql.org/docs/8.0/static/connect-estab.html

            regards, tom lane