Hey short trick :
to avoid to use the schema name multiple time (more readable and more easy
to re use).
You can use the
SET search_path gpstracking_device_tracks, public;
(see manual here :
http://www.postgresql.org/docs/current/static/sql-set.html)
Cheers,
Rémi-C
2013/10/2 Carlos Eduardo
On Mon, Sep 30, 2013 at 10:03 AM, Carlos Eduardo Sotelo Pinto
carlos.sotelo.pi...@gmail.com wrote:
I need a help on postgresql performance
I have configurate my postgresql files for tunning my server, however it is
slow and cpu resources are highter than 120%
I have no idea on how to solve
Thanks to all
I have fix that refactoring the function
BEGIN
arr := regexp_split_to_array(_imeis, E'\\s+');
RETURN QUERY
SELECT
gpstracking_device_tracks.imei,
gpstracking_device_tracks.device_id,
gpstracking_device_tracks.date_time_process,
gpstracking_device_tracks.latitude,