Re: Is This My Speed Limit?

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: CN <cnliou9(at)fastmail(dot)fm>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is This My Speed Limit?
Date: 2003-10-03 05:59:25
Message-ID: 3F7D103D.3070801@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Hi!
>
> It's just my curiosity. I wonder if there is any way to break my speed
> limit on AMD 450Mhz:

> Hash Join (cost=189.79..1508.67 rows=11203 width=48) (actual
> time=129.20..1780.53 rows=9912 loops=1)

> Hash Join (cost=208.74..1751.68 rows=11203 width=58) (actual
> time=135.87..1113.69 rows=9912 loops=1)

Well, it looks like a speed limit. I wouldn't expect better speed for
queries returning 10000 rows.

Regards,
Tomasz Myrta

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory S. Williamson 2003-10-03 06:22:46 Re: count(*) slow on large tables
Previous Message Josh Berkus 2003-10-03 05:27:08 Re: TPC-R benchmarks