[PERFORM] Connection time when using SSL

I am connecting to a Postgres instance using SSL and seeing fairly slow connect times. I would expect there would be some overhead but it's more than I anticipated. The connection is happening over a network. I am using a wildcard SSL certificate on the server side only. Using one of these JDBC

Re: [PERFORM] Query with large number of joins

Andrew Dunstan writes: > Have you tried a) either turning off geqo or setting geqo_threshold > fairly high b) setting join_collapse_limit fairly high (assuming all > the above join targets are tables and not views, setting it to > something like 25 should do the trick. Tom Lane < t...@sss.pgh

Re: [PERFORM] Query with large number of joins

On 10/21/2014 12:31 PM, Andrew Dunstan wrote: > Please don't top-post on the PostgreSQL lists. See > Oops, sorry. >Have you tried a) either turning off geqo or setting geqo_threshold fairly >high b) setting join_collapse_limit fairly high (assuming >all th

Re: [PERFORM] Query with large number of joins

| character varying(40) | not null | extended | | lima | character varying(30) | not null | extended | | global_client_id | character varying(40) | not null | extended | | org_assess_id | integer

[PERFORM] Query with large number of joins

d up the run time of this query or any other Postgres settings we should be aware of when dealing with this unusually large number of joins? Thanks in advance Marco Di Cesare