Postgres Pro
Downloads
Home   >   mailing lists

Re: Is This My Speed Limit? - Mailing list pgsql-performance

From Tomasz Myrta
Subject Re: Is This My Speed Limit?
Date
Msg-id 3F7D103D.3070801@klaster.net
Whole thread Raw
In response to Is This My Speed Limit?  ("CN" <cnliou9@fastmail.fm>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: TPC-R benchmarks
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: count(*) slow on large tables