Re: performance regression in 9.2/9.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: performance regression in 9.2/9.3
Date
Msg-id 31025.1402331501@sss.pgh.pa.us
Whole thread Raw
In response to Re: performance regression in 9.2/9.3  (Linos <info@linos.es>)
Responses Re: performance regression in 9.2/9.3  (Linos <info@linos.es>)
List pgsql-hackers
Linos <info@linos.es> writes:
> On 05/06/14 19:39, Tom Lane wrote:
>> I'd like to see a self-contained test case, by which I mean full details
>> about the table/view schemas; it's not clear whether the actual data
>> is very important here.

> query1 schema file:
> http://pastebin.com/JpqM87dr

Sorry about the delay on getting back to this.  I downloaded the above
schema file and tried to run the originally given query with it, and it
failed because the query refers to a couple of "tienda" columns that
don't exist anywhere in this schema.  When you submit an updated version,
please make sure that all the moving parts match ;-).
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: NUMA packaging and patch
Next
From: Kevin Grittner
Date:
Subject: Re: Inaccuracy in VACUUM's tuple count estimates