Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Linos
On 05/06/14 23:09, Linos wrote: On 05/06/14 19:39, Tom Lane wrote: Merlin Moncure mmonc...@gmail.com writes: On Thu, Jun 5, 2014 at 9:54 AM, Linos i...@linos.es wrote: What I don't understand is why the statistics have this bad information, all my tests are done on a database just restored

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Merlin Moncure
On Mon, Jun 9, 2014 at 9:51 AM, Linos i...@linos.es wrote: Hello, Is this information enough? I could try to assemble a complete test case but I have very little time right now because I am trying to meet a very difficult deadline. I will do ASAP if needed. It is not -- it was enough to

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Linos
On 09/06/14 16:55, Merlin Moncure wrote: On Mon, Jun 9, 2014 at 9:51 AM, Linos i...@linos.es wrote: Hello, Is this information enough? I could try to assemble a complete test case but I have very little time right now because I am trying to meet a very difficult deadline. I will do ASAP

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Merlin Moncure
On Mon, Jun 9, 2014 at 10:00 AM, Linos i...@linos.es wrote: On 09/06/14 16:55, Merlin Moncure wrote: On Mon, Jun 9, 2014 at 9:51 AM, Linos i...@linos.es wrote: Hello, Is this information enough? I could try to assemble a complete test case but I have very little time right now because I am

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Linos
On 09/06/14 17:30, Merlin Moncure wrote: On Mon, Jun 9, 2014 at 10:00 AM, Linos i...@linos.es wrote: On 09/06/14 16:55, Merlin Moncure wrote: On Mon, Jun 9, 2014 at 9:51 AM, Linos i...@linos.es wrote: Hello, Is this information enough? I could try to assemble a complete test case but I

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Tom Lane
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

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Linos
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:

[HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Linos
Hello all, This is a continuation of the thread found here: http://www.postgresql.org/message-id/538f2578.9080...@linos.es Considering this seems to be a problem with the planner I thought that maybe would be a better idea to post this problem here. To summarize the original thread I upgraded

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Linos
On 05/06/14 13:32, Linos wrote: Hello all, This is a continuation of the thread found here: http://www.postgresql.org/message-id/538f2578.9080...@linos.es Considering this seems to be a problem with the planner I thought that maybe would be a better idea to post this problem here. To

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Merlin Moncure
On Thu, Jun 5, 2014 at 6:32 AM, Linos i...@linos.es wrote: Hello all, This is a continuation of the thread found here: http://www.postgresql.org/message-id/538f2578.9080...@linos.es Considering this seems to be a problem with the planner I thought that maybe would be a better idea to post

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Linos
On 05/06/14 16:40, Merlin Moncure wrote: On Thu, Jun 5, 2014 at 6:32 AM, Linos i...@linos.es wrote: Hello all, This is a continuation of the thread found here: http://www.postgresql.org/message-id/538f2578.9080...@linos.es Considering this seems to be a problem with the planner I thought

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Linos
On 05/06/14 16:40, Merlin Moncure wrote: On Thu, Jun 5, 2014 at 6:32 AM, Linos i...@linos.es wrote: Hello all, This is a continuation of the thread found here: http://www.postgresql.org/message-id/538f2578.9080...@linos.es Considering this seems to be a problem with the planner I thought

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Merlin Moncure
On Thu, Jun 5, 2014 at 9:54 AM, Linos i...@linos.es wrote: What I don't understand is why the statistics have this bad information, all my tests are done on a database just restored and analyzed. Can I do something to improve the quality of my database statistics and let the planner do

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Greg Stark
On Thu, Jun 5, 2014 at 3:54 PM, Linos i...@linos.es wrote: What I don't understand is why the statistics have this bad information, all my tests are done on a database just restored and analyzed. Can I do something to improve the quality of my database statistics and let the planner do

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Thu, Jun 5, 2014 at 9:54 AM, Linos i...@linos.es wrote: What I don't understand is why the statistics have this bad information, all my tests are done on a database just restored and analyzed. Can I do something to improve the quality of my

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Linos
On 05/06/14 19:39, Tom Lane wrote: Merlin Moncure mmonc...@gmail.com writes: On Thu, Jun 5, 2014 at 9:54 AM, Linos i...@linos.es wrote: What I don't understand is why the statistics have this bad information, all my tests are done on a database just restored and analyzed. Can I do something