| From: | Michael Stone <mstone+postgres(at)mathom(dot)us> |
|---|---|
| To: | Luke Lonergan <llonergan(at)greenplum(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] A Better External Sort? |
| Date: | 2005-10-06 09:49:34 |
| Message-ID: | 20051006094934.GB17398@mathom.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Wed, Oct 05, 2005 at 04:55:51PM -0700, Luke Lonergan wrote:
>You've proven my point completely. This process is bottlenecked in the CPU.
>The only way to improve it would be to optimize the system (libc) functions
>like "fread" where it is spending most of it's time.
Or to optimize its IO handling to be more efficient. (E.g., use larger
blocks to reduce the number of syscalls.)
Mike Stone
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry Karasik | 2005-10-06 10:28:25 | Re: prepared queries in plperl |
| Previous Message | Simon Riggs | 2005-10-06 07:53:25 | Re: prefix btree implementation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2005-10-06 10:37:36 | Re: [PERFORM] A Better External Sort? |
| Previous Message | Yann Michel | 2005-10-06 08:19:19 | Re: index on custom function; explain |