From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
Cc: pgsql-es-ayuda@postgresql.org
Subject: Re: Fwd: Help on ṕerformance
Date: Mon, 30 Sep 2013 13:12:20 -0300
Message-ID: <20130930161220.GD5235@eldon.alvh.no-ip.org> (raw)
In-Reply-To: <CAEhw=E93QV7OA08XnapEYEob16vvo7bjjFAKFFuyvQSdLp+LWQ@mail.gmail.com>
References: <CAEhw=E9j5s-XO7eXK-WRFakNUuPF46RTjdF2JS0x+WyBtMhnpg@mail.gmail.com>
<CAEhw=E93QV7OA08XnapEYEob16vvo7bjjFAKFFuyvQSdLp+LWQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-es-ayuda>
Carlos Eduardo Sotelo Pinto escribió:
> DECLARE
> arr varchar[];
> BEGIN
> arr := regexp_split_to_array(_imeis, E'\\s+');
> FOR i IN 1..array_length(arr, 1) LOOP
> RETURN QUERY
Creo que deberías hacer una única consulta con todos los elementos del
array, en lugar de una consulta para cada elemento. Es decir, elimina
el LOOP y el LIMIT 1, y tu WHERE debería ser algo como
...
> FROM gpstracking_device_tracks
> WHERE gpstracking_device_tracks.imei = arr[i]::VARCHAR
WHERE gpstracking_device_tracks.imei = ANY (arr) AND ...
Vas a tener que solucionar de otra forma el que te retorne sólo una fila
para cada imei, claro.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda@postgresql.org)
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@2ndquadrant.com, carlos.sotelo.pinto@gmail.com, pgsql-es-ayuda@postgresql.org
Subject: Re: Fwd: Help on ṕerformance
In-Reply-To: <20130930161220.GD5235@eldon.alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox