On 09/06/14 18:31, Tom Lane wrote:
> 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
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
remove4 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
reallybusy 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.
