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

Re: futex results with dbt-3

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: josh(at)agliodbs(dot)com
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: futex results with dbt-3
Date: 2004-10-23 23:20:46
Message-ID: 417AE74E.7030004@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Josh Berkus wrote:
| Gaetano,
|
|
|>I proposed weeks ago to see how the CSStorm is affected by stick each
|>backend in one processor ( where the process was born ) using the
|>cpu-affinity capability ( kernel 2.6 ), is this proposal completely out of
|>mind ?
|
|
| I don't see how that would help.   The problem is not backends switching
| processors, it's the buffermgrlock needing to be swapped between processors.

This is not clear to me. What happen if during a spinlock a backend is
moved away from one processor to another one ?


Regards
Gaetano Mendola




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBeudN7UpzwH2SGd4RAkL9AKCUY9vsw1CPmBV1kC7BKxUtuneN2wCfXaYr
E8utuJI34MAIP8jUm6By09M=
=oRvU
-----END PGP SIGNATURE-----


In response to

pgsql-performance by date

Next:From: Max BakerDate: 2004-10-24 05:08:11
Subject: Re: Vacuum takes a really long time, vacuum full required
Previous:From: Gaetano MendolaDate: 2004-10-23 18:56:58
Subject: Re: futex results with dbt-3

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