On 24 Sep, Greg Stark wrote:
> Ok, I guess I misunderstood you. These queries are taking 0.5ms - 300ms except
> for the last aggregate query which takes just over 1s.
http://developer.osdl.org/markw/dbt2-pgsql/120/
I have more data where I got the response times for each transaction
much lower by
On 25 Sep, Zeugswetter Andreas SB SD 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 taking 0.5ms - 300ms except
>> for the last aggregate query whic
> > >> > 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
[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
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?
>>
>> 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
[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
On 22 Sep, Greg Stark wrote:
>
> [EMAIL PROTECTED] writes:
>
>> http://developer.osdl.org/markw/74/
>
> Are those response times in the right unit? 7-10s?
Yeah, the database really isn't tuned at all. I've gotten some
suggestions off the list that I will be trying. I'll report them as I
compl
[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
http://developer.osdl.org/markw/74/
I had a couple of hiccups doubling the database size,
but I have results with proper linux kernel profile data now. The
increase in database size has decreased the overall performance, as
expected...
I haven't had the opportunity to try different database para
