On 09/06/14 18:31, Tom Lane wrote: > Linos <i...@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 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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
