From: Tom Lane <tgl@sss.pgh.pa.us>
To: Valentina Tedone <valetedo88@gmail.com>
cc: pgsql-admin@postgresql.org
Subject: Re: execution time
In-reply-to: 
 <CAFgLY6w8Thi0wN1QMswrH8J7T03wns5J9MxRmvjEC6tT6ezEOA@mail.gmail.com>
References: 
 <CAFgLY6w8Thi0wN1QMswrH8J7T03wns5J9MxRmvjEC6tT6ezEOA@mail.gmail.com>
Comments: In-reply-to Valentina Tedone <valetedo88@gmail.com>
 message dated "Wed, 18 Feb 2015 09:38:36 +0100"
Date: Wed, 18 Feb 2015 10:19:57 -0500
Message-ID: <1020.1424272797@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Valentina Tedone <valetedo88@gmail.com> writes:
> The problem is about time, infact to solve i.e. this query:

> "SELECT * FROM data d WHERE d.type = 7 AND
> (((d.metadata->'chromosome'->>'value')::text IN ('3','7')) AND
> ((d.metadata->'somatic'->>'value')::boolean = 'true')) and
> ((d.metadata->'filter'->>'value')::text IN ('pass')) LIMIT 30;"

> the first db has an average time about  52.876 ms, the second about
> 470.1172 ms and the bigger one about 58.3572 ms.

> Why is there this difference?it is only for the different strategy?

You have not provided enough detail to let anyone do more than guess.
There is advice here about how to ask answerable questions:
https://wiki.postgresql.org/wiki/Slow_Query_Questions

			regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin