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

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

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

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 don

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

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

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

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 p

[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