Postgres Pro
Downloads
Home   >   mailing lists

Re: Order by (for 15 rows) adds 30 seconds to query time - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Order by (for 15 rows) adds 30 seconds to query time
Date
Msg-id 4B168F87020000250002CF9F@gw.wicourts.gov
Whole thread Raw
In response to Re: Order by (for 15 rows) adds 30 seconds to query time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Order by (for 15 rows) adds 30 seconds to query time
List pgsql-performance
Tree view 
Tom Lane <tgl@sss.pgh.pa.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Order by (for 15 rows) adds 30 seconds to query time
Next
From: Richard Neill
Date:
Subject: Re: Order by (for 15 rows) adds 30 seconds to query time