Re: Looks like merge join planning time is too big, 55 seconds

[Sergey Burladyan <eshkinkot@xxxxxxxxx>]

On Thu, Aug 1, 2013 at 2:04 PM, Thomas Reiss <thomas.reiss@xxxxxxxxxx> wrote:

Le 01/08/2013 11:55, Sergey Burladyan a écrit :

At first look, this reminds me some catalog bloat issue. Can you provide

the result of these queries :
SELECT pg_size_pretty(pg_table_size('pg_class')) AS size_pg_class;
SELECT pg_size_pretty(pg_table_size('pg_attribute')) AS size_pg_attribute;

SELECT pg_size_pretty(pg_table_size('pg_class')) AS size_pg_class; --- '16 MB'

SELECT pg_size_pretty(pg_table_size('pg_attribute')) AS size_pg_attribute; --- '63 MB'

--
Sergey Burladyan