more ideas.
thank you for your help.
Mathieu VINCENT
2015-12-17 11:58 GMT+01:00 Mathieu VINCENT :
> Adding foreign key between on t2 and t3, does not change the plan.
>
> drop table if exists t1;
> drop table if exists t2;
> drop table if exists t3;
>
> create table t1
verbose t2;
analyze verbose t3;
EXPLAIN (analyze on, buffers on, verbose on)
select
*
from
t1 t1
inner join t2 on t1.c1=t2.c1
inner join t3 on t1.c1=t3.c1
Cordialement,
<http://www.psih.fr/>PSIH Décisionnel en santé
Mathieu VINCENT
Data Analyst
PMSIpilot - 61 rue Sully - 69006 Lyon - France
2
inner join t2 on t1.c1=t2.c1
inner join t3 on t2.c1=t3.c1
the explain plan : http://explain.depesz.com/s/YVw
Do you understand how postgresql calculate the row estimate ?
BR
Mathieu VINCENT
2015-12-17 10:14 GMT+01:00 Matteo Grolla :
> Thank you both for the help!
> happy holidays
>
> 2
, the estimate is good : http://explain.depesz.com/s/gCX
Have a good day
Mathieu VINCENT
2015-12-15 11:21 GMT+01:00 Gunnar "Nick" Bluth <
gunnar.bluth.ext...@elster.de>:
> Am 15.12.2015 um 10:49 schrieb Andreas Kretschmer:
> > Gunnar Nick Bluth wrote:
> >
> >>
Hello,
No one to help me to understand this bad estimation rows ?
Mathieu VINCENT
2015-12-11 12:35 GMT+01:00 Mathieu VINCENT :
> Sorry, I forget to precise Postgresql version
>
> 'PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
> 20120313 (Red Hat
Sorry, I forget to precise Postgresql version
'PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-11), 64-bit'
BR
Mathieu VINCENT
2015-12-11 9:53 GMT+01:00 Mathieu VINCENT :
> Hello,
>
> I would like to know how row estima
estimation ?
Thank you for answering
Best Regards,
<http://www.psih.fr/>PSIH Décisionnel en santé
Mathieu VINCENT
Data Analyst
PMSIpilot - 61 rue Sully - 69006 Lyon - France