Larry Rosenman wrote: > Jim C. Nasby wrote: >> On Thu, Apr 20, 2006 at 08:06:30PM +0200, Magnus Hagander wrote: >>> It reuqires a multi-CPU box, right? I don't hav eone with pgwin32 on >>> ATM. Do you know if it's enough with hyperthreading? >> >> Hrm... not sure. Let me see if I can find a box with HT here and test >> it. Running the following batch file with arguments of 40 40 1000 is >> almost guaranteed to trigger the problem, though... >> >> @echo off >> dropdb bench >> createdb bench >> pgbench -i -s %1 bench >> pgbench -t %3 -c %2 -n bench > > It seems to hang up just fine on my XPSP2, PG 8.1.2 HTT box. > > :( > > LER
I may have spoken too soon :( More in a bit. LER -- Larry Rosenman Database Support Engineer PERVASIVE SOFTWARE. INC. 12365B RIATA TRACE PKWY 3015 AUSTIN TX 78727-6531 Tel: 512.231.6173 Fax: 512.231.6597 Email: [EMAIL PROTECTED] Web: www.pervasive.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend