Re: performance regression in 9.2/9.3

On 09/06/14 18:31, Tom Lane wrote:
> Linos <info(at)linos(dot)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

Tom are you trying with the modified query 1 I posted in the email you found the schema link? I changed a little bit to remove 4 views, these views were where tienda columns were.

Here you can find the modified query and the new explain without these views.

http://pastebin.com/7u2Dkyxp
http://explain.depesz.com/s/2V9d

Anyway Merlin told me how to create a more complete self-contained case without data, I will try to do it ASAP, I am really busy right now trying to meet a deadline but I will try to search for a while to create this test-case.

Thank you Tom.

Regards,
Miguel Angel.