SV: force partition pruning - Mailing list pgsql-general

From Niels Jespersen
Subject SV: force partition pruning
Date
Msg-id e5394e430cd74d3199437dc20d944c81@dst.dk
Whole thread Raw
In response to Re: force partition pruning  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Responses Re: force partition pruning
List pgsql-general

>Sorry,

>I made a major mistake. I somehow saw the period and period_version as the same.

>so, yes partitions are not pruned here. So my suggestion makes no sense.

 

Thats quite ok. I think my plan now is to have a table returning function that executes a query dynamically. The query has a where caluse that is first constructed.

 

Like this:

 

 

return query execute format('select d.x, d.y from %1$I.%1$I d where d.period_version = any(' || quote_literal(_periode_version_array) ||'::text[])', register_in);

 

Regards Niels

 

 

pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: force partition pruning
Next
From: Christopher Sumner
Date:
Subject: Sequence gaps after restart