What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-09 Thread Bharath Rupireddy
Hi, I've always had a hard time distinguishing various types of processes/terms used in postgres. I look at the source code every time to understand them, yet I don't feel satisfied with my understanding. I request any hacker (having a better idea than me) to help me with what each different proce

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-09-06 Thread Alvaro Herrera
On 2021-Aug-14, Justin Pryzby wrote: > I elaborated on your definition and added here. > https://commitfest.postgresql.org/34/3285/ Thanks! This works for me. After looking at it, it seemed to me that listing the autovacuum launcher is perfectly adapted, so we might as well do it; and add verbi

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-09-06 Thread Justin Pryzby
On Mon, Sep 06, 2021 at 09:18:13PM -0300, Alvaro Herrera wrote: > On 2021-Aug-14, Justin Pryzby wrote: > > > I elaborated on your definition and added here. > > https://commitfest.postgresql.org/34/3285/ > > Thanks! This works for me. After looking at it, it seemed to me that > listing the auto

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-09-07 Thread Bharath Rupireddy
On Tue, Sep 7, 2021 at 5:48 AM Alvaro Herrera wrote: > > On 2021-Aug-14, Justin Pryzby wrote: > > > I elaborated on your definition and added here. > > https://commitfest.postgresql.org/34/3285/ > > Thanks! This works for me. After looking at it, it seemed to me that > listing the autovacuum lau

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-09-13 Thread Alvaro Herrera
Thanks Bharath and Justin -- I think I took all the suggestions and made a few other changes of my own. Here's the result. I'm not 100% happy with the historical note in "startup process", mostly because it uses the word "name" three times too close to each other. Didn't quickly see an obvious wa

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-09-20 Thread Alvaro Herrera
On 2021-Sep-13, Alvaro Herrera wrote: > Thanks Bharath and Justin -- I think I took all the suggestions and made > a few other changes of my own. Here's the result. Pushed this with very minor additional changes, thanks. -- Álvaro Herrera PostgreSQL Developer — https://www.Enterprise

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-15 Thread Bharath Rupireddy
On Tue, Jul 13, 2021 at 3:00 AM Stephen Frost wrote: > > Greetings, > > * Bharath Rupireddy (bharath.rupireddyforpostg...@gmail.com) wrote: > > I've always had a hard time distinguishing various types of > > processes/terms used in postgres. I look at the source code every time > > to understand t

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-15 Thread Justin Pryzby
On Fri, Jul 09, 2021 at 09:24:19PM +0530, Bharath Rupireddy wrote: > I've always had a hard time distinguishing various types of > processes/terms used in postgres. I look at the source code every time > to understand them, yet I don't feel satisfied with my understanding. > I request any hacker (h

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-16 Thread Bharath Rupireddy
On Thu, Jul 15, 2021 at 8:17 PM Justin Pryzby wrote: > > On Fri, Jul 09, 2021 at 09:24:19PM +0530, Bharath Rupireddy wrote: > > I've always had a hard time distinguishing various types of > > processes/terms used in postgres. I look at the source code every time > > to understand them, yet I don't

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-17 Thread Alvaro Herrera
On 2021-Jul-17, Bharath Rupireddy wrote: > On Thu, Jul 15, 2021 at 8:17 PM Justin Pryzby wrote: > > > > On Fri, Jul 09, 2021 at 09:24:19PM +0530, Bharath Rupireddy wrote: > > > I've always had a hard time distinguishing various types of > > > processes/terms used in postgres. I look at the source

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-17 Thread Justin Pryzby
On Sat, Jul 17, 2021 at 10:45:52AM -0400, Alvaro Herrera wrote: > On 2021-Jul-17, Bharath Rupireddy wrote: > > > On Thu, Jul 15, 2021 at 8:17 PM Justin Pryzby wrote: > > > > > > On Fri, Jul 09, 2021 at 09:24:19PM +0530, Bharath Rupireddy wrote: > > > > I've always had a hard time distinguishing v

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-17 Thread Tom Lane
Justin Pryzby writes: > On Sat, Jul 17, 2021 at 10:45:52AM -0400, Alvaro Herrera wrote: >> Process of an instance in >> charge of some specific, hardcoded background task. Examples are > And I think "hardcoded" doesn't mean anything beyond what "specific" means. > Maybe you'd say: .. process wh

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-08-14 Thread Justin Pryzby
On Sat, Jul 17, 2021 at 10:45:52AM -0400, Alvaro Herrera wrote: > On 2021-Jul-17, Bharath Rupireddy wrote: > > On Thu, Jul 15, 2021 at 8:17 PM Justin Pryzby wrote: > > > It sounds like something that should be in the glossary, which currently > > > refers > > > to but doesn't define "auxiliary pro

Re: What are exactly bootstrap processes, auxiliary processes, standalone backends, normal backends(user sessions)?

2021-07-12 Thread Stephen Frost
Greetings, * Bharath Rupireddy (bharath.rupireddyforpostg...@gmail.com) wrote: > I've always had a hard time distinguishing various types of > processes/terms used in postgres. I look at the source code every time > to understand them, yet I don't feel satisfied with my understanding. > I request