Re: URGENT HELP about 'duration' stats - Mailing list pgsql-hackers

From Camilo Porto
Subject Re: URGENT HELP about 'duration' stats
Date
Msg-id BLU111-W11F14CA3300A0720458C25BC920@phx.gbl
Whole thread Raw
In response to Re: URGENT HELP about 'duration' stats  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
Responses Re: URGENT HELP about 'duration' stats
List pgsql-hackers


[Camilo Porto]



> Date: Sat, 27 Oct 2007 18:12:28 +0100
> From: plk.zuber@gmail.com
> To: camiloporto@hotmail.com
> Subject: Re: [HACKERS] URGENT HELP about 'duration' stats
> CC: pgsql-hackers@postgresql.org
>
> 2007/10/27, Camilo Porto <camiloporto@hotmail.com>:
>
> > The parallelism happens even if my PC has only one processor?
>
> PostgreSQL creates a separate process for each client connection -
> whether you have one CPU or more.
>
> > Each query is executed in a separeted Thread?
> No threads, at least on Unix. Regular processes (sometimes called backends).
>
> > I am simulating only 1 client with the Benchmark. Can 1 Client submit
> > parallel queries, in single-processor enviroment?
> If this client uses two connections, you can run two queries in paralell.
    The client uses only 1 connection. In this situation is possible that the EXECUTOR's duration time become greater than the time period which the Query was observed? (as stated in my first topic)?
>
>
> this chapter of documentation can be helpful:
> http://www.postgresql.org/docs/8.2/static/overview.html


Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça o MSN Mobile! Cadastre-se já!

pgsql-hackers by date:

Previous
From: "Gevik Babakhani"
Date:
Subject: Proposal TODO Item: SQL-language reference parameters by name
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Multiple trees in parsetree_list