Thanks Andreas,
Il try
2015-12-15 11:07 GMT+01:00 Andreas Kretschmer :
> Matteo Grolla wrote:
>
> >
> > ---Questions
> >
> > 1) Can you explain me the big difference between the result in A for
> table
> > alf_node_properties: 17GB and the result in B: ~6GB ?
> >
> > 2)
Am 15.12.2015 um 10:49 schrieb Andreas Kretschmer:
> Gunnar Nick Bluth wrote:
>
>> Am 15.12.2015 um 09:05 schrieb Mathieu VINCENT:
>>> Hello,
>>>
>>> No one to help me to understand this bad estimation rows ?
>>
>> Well,
>>
>> on a rather beefy machine, I'm getting quite a different plan:
>> http
Matteo Grolla wrote:
>
> ---Questions
>
> 1) Can you explain me the big difference between the result in A for table
> alf_node_properties: 17GB and the result in B: ~6GB ?
>
> 2) Can you explain me the difference between the result in B: ~6GB and the
> result in C, the sum
Hi,
I hope you can help me understand why the db is so big and if there's
anything I can do.
It's the DB of an Enterprise Content Management application, Alfresco. Here
are some data I collected, after executing a vaccum from pg admin.
A) Largest tables sizes relation total_size
SELECT nspn
Gunnar Nick Bluth wrote:
> Am 15.12.2015 um 09:05 schrieb Mathieu VINCENT:
> > Hello,
> >
> > No one to help me to understand this bad estimation rows ?
>
> Well,
>
> on a rather beefy machine, I'm getting quite a different plan:
> http://explain.depesz.com/s/3y5r
you are using 9.5, right? Go
Am 15.12.2015 um 09:05 schrieb Mathieu VINCENT:
> Hello,
>
> No one to help me to understand this bad estimation rows ?
Well,
on a rather beefy machine, I'm getting quite a different plan:
http://explain.depesz.com/s/3y5r
Which may be related to this setting:
perftest=# show default_statistics_
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 4.4.7-11), 64-bit'
>
