On Wed, Jul 27, 2016 at 11:15 AM, Félix GERZAGUET wrote:
> I don't know how to give the planner more accurate info ...
>
Could you try to materialize the e.name subquery in another table. As in
create table func_var_name_for_tpl_15 as
se
Hello Lana,
On Wed, Jul 27, 2016 at 8:03 AM, Abadie Lana wrote:
> Here the result of explain (analyse, buffer). Thanks for your help and let
> me know if you need more information.
I noticed 3 things in your query:
1. In the second part (after the except), the 2 tables utva and utv are not
jo
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
