Call for trace_sort output/details

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-perform(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Call for trace_sort output/details
Date: 2005-11-16 18:58:27
Message-ID: 1132167507.4959.45.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm interested in any performance reports for long running sort runs in
8.1, as background information to improving sort performance for 8.2.
You'll need to enable the trace_sort parameter.

If you could provide all of the following, that would be most helpful

1. the log output relating to the trace_sort

2. details of the SQL query invoking the sort
3. details of the table(s) involved
so I can determine
i) the columns and datatypes of the sort keys.
ii) the total data volume being sorted

4. Any analysis you have of the data distributions, i.e. first column
has 1 million unique values, 2nd sort column has 11 values etc..

5. your work_mem and maintenance work_mem settings
6. server hardware details

First few posts can be on-list, after that privately please - until I
shout stop! Please only send me your worst sort case, not every case...

Any help much appreciated.

Best Regards, Simon Riggs

Browse pgsql-general by date

  From Date Subject
Next Message Piccarello, James (James) 2005-11-16 19:07:22 Re: PostgreSQL compatible with Real Time Linux ?
Previous Message Greg Stark 2005-11-16 18:57:56 Re: locked backend