topic Re: How to add index in postgres using Talend in Talend Studio

How to add index in postgres using Talend

m3h3r — Sat, 16 Nov 2024 00:34:04 GMT

Hi,

I need to make my ETL process fast. So I want to first CREATE INDEX in tables postgres and run the job. I use component TDBRow but i didn't find the query.

Please suggest a way to do this.

Thanks

Re: How to add index in postgres using Talend

root — Mon, 22 Feb 2021 15:17:09 GMT

You can try https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F744&pi=marketplace%252F1%252Fproducts%252F744%252Fitems%252F1050

We use it to run adhoc DDL queries.