[PERFORM] Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?

On Tue, Oct 8, 2013 at 3:48 AM, Aftab Ahmed Chandio wrote: > What do u suggest me, where I need to make performance tuning? w hich > configuration setting must need to modify in the linux? Well, others have already pointed out that you should first measure your query on the server. I would point

[PERFORM] Is there a Maximum number of partitions in which constraint_exclusion works?

I've been working with partitions (I have split my table in around 3000 partitions), and if i did some like this SELECT * FROM my_parent_table WHERE some_value_in_which_partitioned_my_table in (34, 36, 48) constraint_exclusion works, (looking EXPLAIN, I can see that in planner only check the part