Re: Order by (for 15 rows) adds 30 seconds to query time

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <Richard Neill <rn214(at)cam(dot)ac(dot)uk>
Cc: "Matthew Wakeling" <matthew(at)flymine(dot)org>,<jmpoure(at)free(dot)fr>, "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>, "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Order by (for 15 rows) adds 30 seconds to query time
Date: 2009-12-02 22:02:15
Message-ID: 4B168F87020000250002CF9F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> That does look weird. Do we have a self-contained test case?

Richard, could you capture the schema for the affected tables and
views with pg_dump -s and also the related rows from pg_statistic?
(The actual table contents aren't needed to see this issue.)

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Neill 2009-12-02 23:04:31 Re: Order by (for 15 rows) adds 30 seconds to query time
Previous Message Tom Lane 2009-12-02 21:48:32 Re: Order by (for 15 rows) adds 30 seconds to query time