Re: [HACKERS] performance regression in 9.2/9.3

2014-06-09 Thread Linos
On 09/06/14 18:31, Tom Lane wrote: > Linos 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:

Re: [HACKERS] performance regression in 9.2/9.3

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

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 wrote: >> On 09/06/14 16:55, Merlin Moncure wrote: >>> On Mon, Jun 9, 2014 at 9:51 AM, Linos wrote: Hello, Is this information enough? I could try to assemble a complete test case but I have ver

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 wrote: > On 09/06/14 16:55, Merlin Moncure wrote: >> On Mon, Jun 9, 2014 at 9:51 AM, Linos 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 me

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 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 9:51 AM, Linos 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 diagnos

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 writes: >>> On Thu, Jun 5, 2014 at 9:54 AM, Linos 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

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 writes: >> On Thu, Jun 5, 2014 at 9:54 AM, Linos 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 qual

Re: [HACKERS] performance regression in 9.2/9.3

2014-06-05 Thread Tom Lane
Merlin Moncure writes: > On Thu, Jun 5, 2014 at 9:54 AM, Linos 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

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 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 better choices

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 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 better choices

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 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 tha

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 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 tha

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 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 pr

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. >

[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 a