Re: [PERFORM] Performance issue in PostgreSQL server...

2017-03-03 Thread Tom Lane
Dinesh Chandra 12108 writes: > The below is the output for psql=> EXPLAIN ANALYZE SELECT DISTINCT feature_id > FROM evidence.point p INNER JOIN evidence.observation_evidence oe ON > p.feature_id = oe.evd_feature_id WHERE p.domain_class_id IN (11) AND > (p.modification_time > '2015-05-10 00:06:5

Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10)

2017-03-03 Thread Merlin Moncure
On Thu, Mar 2, 2017 at 3:51 PM, Pietro Pugni wrote: > The HBA provided slightly better performance without removing the expander > and even more slightly faster after removing the expander, but then I tried > increasing numjob from 1 to 16 (tried also 12, 18, 20, 24 and 32 but found > 16 to get hi

Re: [PERFORM] Performance issue in PostgreSQL server...

2017-03-03 Thread Dinesh Chandra 12108
Dear Nur, The below is the output for psql=> EXPLAIN ANALYZE SELECT DISTINCT feature_id FROM evidence.point p INNER JOIN evidence.observation_evidence oe ON p.feature_id = oe.evd_feature_id WHERE p.domain_class_id IN (11) AND (p.modification_time > '2015-05-10 00:06:56.056 IST' OR oe.modificati

Re: [PERFORM] Performance issue in PostgreSQL server...

2017-03-03 Thread Nur Agus
Hello Dinesh, You can try the EXPLAIN tool psql=> EXPLAIN ANALYZE SELECT DISTINCT feature_id FROM evidence.point p INNER JOIN evidence.observation_evidence oe ON p.feature_id = oe.evd_feature_id WHERE p.domain_class_id IN (11) AND (p.modification_time > '2015-05-10 00:06:56.056 IST' OR oe.modific

[PERFORM] Performance issue in PostgreSQL server...

2017-03-03 Thread Dinesh Chandra 12108
Dear Experts, I need your suggestions to resolve the performance issue reported on our PostgreSQL9.1 production database having 1.5 TB Size. I have observed that, some select queries with order by clause are taking lot of time in execution and forcing applications to give slow response. The co

Re: [PERFORM] Speeding up JSON + TSQUERY + GIN

2017-03-03 Thread Sven R. Kunze
On 01.03.2017 18:04, Jeff Janes wrote: On Wed, Mar 1, 2017 at 6:02 AM, Sven R. Kunze > wrote: On 28.02.2017 17:49, Jeff Janes wrote: Oh. In my hands, it works very well. I get 70 seconds to do the {age: 20} query from pure cold caches, versus 1.4 seconds fr