pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed[kris@obsecurity.org: Anyone interested in improving postgresql scaling?]
2+ messages / 2 participants
[nested] [flat]
* [kris@obsecurity.org: Anyone interested in improving postgresql scaling?]
@ 2007-02-27 18:32 Jim C. Nasby <decibel@decibel.org>
0 siblings, 1 reply; 2+ messages in thread
From: Jim C. Nasby @ 2007-02-27 18:32 UTC (permalink / raw)
To: pgsql-performance
Ok, looks like the FreeBSD community is interested in PostgreSQL
performance, or at least enough to investigate it.
Anyone here have experience hacking on FreeBSD?
----- Forwarded message from Kris Kennaway <kris@obsecurity.org> -----
X-Spam-Checker-Version: SpamAssassin 3.1.6 (2006-10-03) on noel.decibel.org
X-Spam-Level:
X-Spam-Status: No, score=-0.9 required=5.0 tests=AWL,BAYES_50,
FORGED_RCVD_HELO,SPF_PASS autolearn=no version=3.1.6
Date: Sun, 25 Feb 2007 19:22:35 -0500
From: Kris Kennaway <kris@obsecurity.org>
To: current@FreeBSD.org
User-Agent: Mutt/1.4.2.2i
Cc: performance@FreeBSD.org
Subject: Anyone interested in improving postgresql scaling?
Precedence: list
Errors-To: owner-freebsd-current@freebsd.org
If so, then your task is the following:
Make SYSV semaphores less dumb about process wakeups. Currently
whenever the semaphore state changes, all processes sleeping on the
semaphore are woken, even if we only have released enough resources
for one waiting process to claim. i.e. there is a thundering herd
wakeup situation which destroys performance at high loads. Fixing
this will involve replacing the wakeup() calls with appropriate
amounts of wakeup_one().
Kris
_______________________________________________
freebsd-current@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-current
To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"
----- End forwarded message -----
--
Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828
Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [kris@obsecurity.org: Anyone interested in improving postgresql scaling?]
@ 2007-02-27 18:54 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jim C. Nasby <decibel@decibel.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-02-27 18:54 UTC (permalink / raw)
To: Jim C. Nasby <decibel@decibel.org>; +Cc: pgsql-performance
"Jim C. Nasby" <decibel@decibel.org> writes:
> Ok, looks like the FreeBSD community is interested in PostgreSQL
> performance, or at least enough to investigate it.
I think this guy is barking up the wrong tree though, because we don't
ever have multiple processes sleeping on the same sema. Not that
there's anything wrong with his proposal, but it doesn't affect Postgres.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-02-27 18:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-27 18:32 [kris@obsecurity.org: Anyone interested in improving postgresql scaling?] Jim C. Nasby <decibel@decibel.org>
2007-02-27 18:54 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox