Re: [HACKERS] More Prelimiary DBT-2 Test Results with PostgreSQL 7.3.4

2003-09-25 Thread Zeugswetter Andreas SB SD
> > >> > Are those response times in the right unit? 7-10s? > > > > No problem: http://developer.osdl.org/markw/misc/plana.out > > Ok, I guess I misunderstood you. These queries are taking 0.5ms - 300ms except > for the last aggregate query which takes just over 1s. Yes, but because this is a be

Re: [HACKERS] More Prelimiary DBT-2 Test Results with PostgreSQL 7.3.4

2003-09-24 Thread Greg Stark
[EMAIL PROTECTED] writes: > On 24 Sep, Greg Stark wrote: > > [EMAIL PROTECTED] writes: > > > >> On 22 Sep, Greg Stark wrote: > >> > Are those response times in the right unit? 7-10s? > > No problem: http://developer.osdl.org/markw/misc/plana.out Ok, I guess I misunderstood you. These queries are

Re: [HACKERS] More Prelimiary DBT-2 Test Results with PostgreSQL 7.3.4

2003-09-24 Thread Greg Stark
[EMAIL PROTECTED] writes: > On 22 Sep, Greg Stark wrote: > > Are those response times in the right unit? 7-10s? > > The plans (http://developer.osdl.org/markw/74/db/plan0.out) don't show > any table scans. They appears to be mostly index scans. There aren't > any batch updates. Would it be eas

Re: [HACKERS] More Prelimiary DBT-2 Test Results with PostgreSQL 7.3.4

2003-09-22 Thread Greg Stark
[EMAIL PROTECTED] writes: > http://developer.osdl.org/markw/74/ Are those response times in the right unit? 7-10s? Are these mostly full table scans and big batch updates? Personally, I'm more interested in seeing OLTP-oriented benchmarks testing quick index based transactions in the 20-200ms