Re: postgres pg_bulkload c filter function in c programming

From: rajmhn <rajmhn(dot)ram(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres pg_bulkload c filter function in c programming
Date: 2016-12-29 19:41:09
Message-ID: 1483040469424-5936695.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Francis.That seems to be a good solution.

Thought to use pg_bulkload, a third party library instead of copy, where
reject handling can be done in efficient way. Transformation(FILTER)
functions can be implemented with any languages in pg_bulkload before it was
loaded to table. SQL, C, PLs are ok, but you should write functions as fast
as possible because they are called many times.

In this case, function should be written in Perl and called inside the
Postgressql function. Do you think that will work it out? But pg_bulkload is
preferring C function over SQL function for performance.

I will try this option as you suggested.

Thanks

--
View this message in context: http://postgresql.nabble.com/postgres-pg-bulkload-c-filter-function-in-c-programming-tp5936651p5936695.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2016-12-29 20:14:36 Re: postgres pg_bulkload c filter function in c programming
Previous Message Francisco Olarte 2016-12-29 19:04:51 Re: postgres pg_bulkload c filter function in c programming