Re: Using indexes through a plpgsql procedure

2021-04-07 Thread Peter J. Holzer
On 2021-04-07 12:15:37 +0100, Ciaran Doherty wrote: > As a quick question. Can Postgres make use of indexes on a table when the data > from that table is being returned from a procedure? > > Some more details. I have a big table which has a long running query running > on > it. This table gets re

Using indexes through a plpgsql procedure

2021-04-07 Thread Ciaran Doherty
Hello, Thank you for taking the time to read this. As a quick question. Can Postgres make use of indexes on a table when the data from that table is being returned from a procedure? Some more details. I have a big table which has a long running query running on it. This table gets rebuilt from