Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] SRA Win32 sync() code

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>,PostgreSQL Win32 port list <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: [PATCHES] SRA Win32 sync() code
Date: 2003-11-17 10:28:34
Message-ID: 1069064914.20092.41.camel@fuji.krosing.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32pgsql-patches
Bruce Momjian kirjutas E, 17.11.2003 kell 03:58:

> 
> OK, let me give you my logic and you can tell me where I am wrong.
> 
> First, how many backend can a single write process support if all the
> backends are doing insert/update/deletes?  5?  10?  Let's assume 10. 
> Second, once we change write to write/fsync, how much slower will that
> be?  100x, 1000x?  Let's say 10x.
> 
> So, by my logic, if we have 100 backends all doing updates, we will need
> 10 * 100 or 1000 writer processes or threads to keep up with that load. 
> That seems quite excessive to me from a context switching and process
> overhead perspective.
> 
> Where am I wrong?

Maybe you meant 100/10 instead of 100*10 ;)

------------
Hannu

In response to

Responses

pgsql-hackers by date

Next:From: Shridhar DaithankarDate: 2003-11-17 10:43:28
Subject: Re: start of transaction
Previous:From: Hannu KrosingDate: 2003-11-17 10:19:06
Subject: Re: start of transaction (was: Re: [PERFORM] Help with

pgsql-patches by date

Next:From: Bruce MomjianDate: 2003-11-17 15:32:11
Subject: Re: [PATCHES] SRA Win32 sync() code
Previous:From: Christopher Kings-LynneDate: 2003-11-17 09:05:45
Subject: improve psql lo_* help

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2003-11-17 14:28:22
Subject: Re: [PATCHES] SRA Win32 sync() code
Previous:From: Shridhar DaithankarDate: 2003-11-17 08:15:49
Subject: Re: [pgsql-hackers-win32] SRA Win32 sync() code

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group