rmance-ow...@postgresql.org]<mailto:[mailto:pgsql-performance-ow...@postgresql.org]>
On Behalf Of Genc, Ömer
Sent: Friday, August 21, 2015 8:49 AM
To: pgsql-performance@postgresql.org<mailto:pgsql-performance@postgresql.org>
Subject: [PERFORM] Performance bottleneck due to array manipula
From: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Genc, Ömer
Sent: Friday, August 21, 2015 8:49 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Performance bottleneck due to array manipulation
Hey,
i have a very long running
Hello,
On Fri, Aug 21, 2015 at 2:48 PM, Genc, Ömer
wrote:
> Now I want to delete all entries from ims_point, where the timestamp is
> older than one hour. The currently being referenced ids of the table
> ims_object_header should be excluded from this deletion.
>
>
>
delete from public.ims_poin
=?iso-8859-1?Q?Genc=2C_=D6mer?= writes:
> i have a very long running stored procedure, due to array manipulation in a
> stored procedure. The following procedure takes 13 seconds to finish.
> BEGIN
> point_ids_older_than_one_hour := '{}';
> object_ids_to_be_invalidated := '{}';
> se
Hey,
i have a very long running stored procedure, due to array manipulation in a
stored procedure. The following procedure takes 13 seconds to finish.
BEGIN
point_ids_older_than_one_hour := '{}';
object_ids_to_be_invalidated := '{}';
select ARRAY(SELECT
point_id
