Re: [osdldbt-general] Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-09 Thread Mary Edie Meredith
On Fri, 2003-09-05 at 15:16, Manfred Spraul wrote: > Another question: > Is it possible to apply patches to postgresql before a DBT-2 run, or is > only patching the kernel supported? > > -- > Manfred As Mark indicated, we currently only support kernel patches via our PLM system, but we are i

Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-05 Thread markw
On 4 Sep, Manfred Spraul wrote: > [EMAIL PROTECTED] wrote: > >>http://developer.osdl.org/markw/44/ >> >>I threw together (kind of sloppily) a web page of the data I was >>starting to collect for our DBT-2 workload (TPC-C derivative) on >>PostgreSQL 7.3.4. Keep in mind not much database tuning has

Re: [osdldbt-general] Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-05 Thread markw
On 6 Sep, Manfred Spraul wrote: > Another question: > Is it possible to apply patches to postgresql before a DBT-2 run, or is > only patching the kernel supported? The data I reported is from a test system I'm using in our lab, so I can certainly try patches. The current state of STP only allow

Re: [osdldbt-general] Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-05 Thread Manfred Spraul
Another question: Is it possible to apply patches to postgresql before a DBT-2 run, or is only patching the kernel supported? -- Manfred ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [osdldbt-general] Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-05 Thread markw
On 4 Sep, Manfred Spraul wrote: > [EMAIL PROTECTED] wrote: > >>http://developer.osdl.org/markw/44/ >> >>I threw together (kind of sloppily) a web page of the data I was >>starting to collect for our DBT-2 workload (TPC-C derivative) on >>PostgreSQL 7.3.4. Keep in mind not much database tuning has

Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-05 Thread Bruce Momjian
Shridhar Daithankar wrote: > For heavily updated systems, you should have WAL buffers bit more. I don't know > exact imact of that setting though. You could try 32/64/128. On the same note, > if you are getting checkpoints too frequently, you can try increasing > checkpoint segments. The logs wi

Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-05 Thread Shridhar Daithankar
On 4 Sep 2003 at 10:53, [EMAIL PROTECTED] wrote: > http://developer.osdl.org/markw/44/ > > I threw together (kind of sloppily) a web page of the data I was > starting to collect for our DBT-2 workload (TPC-C derivative) on > PostgreSQL 7.3.4. Keep in mind not much database tuning has been done >

Re: [HACKERS] Prelimiary DBT-2 Test results

2003-09-04 Thread Manfred Spraul
[EMAIL PROTECTED] wrote: http://developer.osdl.org/markw/44/ I threw together (kind of sloppily) a web page of the data I was starting to collect for our DBT-2 workload (TPC-C derivative) on PostgreSQL 7.3.4. Keep in mind not much database tuning has been done yet. Feel free to ask any questions