Yeah, I'm sure binding each process to a CPU would be a significant
help. Something I've always wanted to quantify but haven't made time for...
Mark
Luke Lonergan wrote:
One of our customers noticed that there were a high number of NUMA cache
misses on a quad core opteron system running Bizgr
One of our customers noticed that there were a high number of NUMA cache
misses on a quad core opteron system running Bizgres MPP resulting in about
a 15% performance hit. We use a process-based parallelization approach and
we can guess that there's context switching due to the high degree of
pipe
Luke Lonergan wrote:
+1
Mark, can you quantify the impact of not running with IRQ balancing enabled?
Whoops, look like performance was due more to enabling the
--enable-thread-safe flag.
IRQ balancing on : 7086.75
http://dbt.osdl.org/dbt/dbt2dev/results/dev4-015/158/
IRQ balancing o
+1
Mark, can you quantify the impact of not running with IRQ balancing enabled?
- Luke
Msg is shrt cuz m on ma treo
-Original Message-
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
Luke Lonergan wrote:
+1
Mark, can you quantify the impact of not running with IRQ balancing enabled?
Yeah, I'll try to have that done within a couple of days.
Mark
---(end of broadcast)---
TIP 5: don't forget to increase your free space map set
On Mon, Oct 09, 2006 at 10:37:32AM -0700, Mark Wong wrote:
> Jim C. Nasby wrote:
> >On Sun, Oct 08, 2006 at 05:26:11PM -0700, Mark Wong wrote:
> >>I made another couple of gross mistakes of forgetting to compile
> >>PostgreSQL with --enable-thread-safe and enabling the user space irq
> >>balancing
Jim C. Nasby wrote:
On Sun, Oct 08, 2006 at 05:26:11PM -0700, Mark Wong wrote:
I made another couple of gross mistakes of forgetting to compile
PostgreSQL with --enable-thread-safe and enabling the user space irq
balancing program in Linux. I've restarted the histories with 600 and
What's the
On Sun, Oct 08, 2006 at 05:26:11PM -0700, Mark Wong wrote:
> I made another couple of gross mistakes of forgetting to compile
> PostgreSQL with --enable-thread-safe and enabling the user space irq
> balancing program in Linux. I've restarted the histories with 600 and
What's the advantage of irq
Michael Paesold wrote:
> [EMAIL PROTECTED] wrote:
>>> Mark Wong <[EMAIL PROTECTED]> writes:
After over a year of problems (old site
http://developer.osdl.org/markw/postgrescvs/) I have resumed producing
daily results of dbt-2 against PostgreSQL CVS code with results here:
h
Tom Lane wrote:
> Mark Wong <[EMAIL PROTECTED]> writes:
>> After over a year of problems (old site
>> http://developer.osdl.org/markw/postgrescvs/) I have resumed producing
>> daily results of dbt-2 against PostgreSQL CVS code with results here:
>> http://dbt.osdl.org/dbt2.html
>
> This is
[EMAIL PROTECTED] wrote:
Mark Wong <[EMAIL PROTECTED]> writes:
After over a year of problems (old site
http://developer.osdl.org/markw/postgrescvs/) I have resumed producing
daily results of dbt-2 against PostgreSQL CVS code with results here:
http://dbt.osdl.org/dbt2.html
This is good
> Mark Wong <[EMAIL PROTECTED]> writes:
>> After over a year of problems (old site
>> http://developer.osdl.org/markw/postgrescvs/) I have resumed producing
>> daily results of dbt-2 against PostgreSQL CVS code with results here:
>> http://dbt.osdl.org/dbt2.html
>
> This is good to hear! I a
Mark Wong <[EMAIL PROTECTED]> writes:
> After over a year of problems (old site
> http://developer.osdl.org/markw/postgrescvs/) I have resumed producing
> daily results of dbt-2 against PostgreSQL CVS code with results here:
> http://dbt.osdl.org/dbt2.html
This is good to hear! I am curi
13 matches
Mail list logo
