After reading this thread, I think I like WHERE better than FILTER.
Tally:
WHERE: Adam Berlin, Lim Myungkyu, Dean Rasheed, yours truly
FILTER: Tomas Vondra, Surafel Temesgen
Couldn't find others expressing an opinion in this regard.
On 2018-Nov-30, Tomas Vondra wrote:
> I think it should be enough just to switch to CIM_SINGLE and increment the
> command counter after each inserted row.
Do we apply command counter increment per row with some other COPY
option? Per-row CCI makes me a bit uncomfortable because with you'd get
in trouble with a large copy. I think it's particularly nasty here,
precisely because you may want to filter out some rows of a very large
file, and the CCI may prevent that from working.
I'm not convinced by the example case of reading how many tuples you've
imported so far in the WHERE/WHEN/FILTER clause each time (that'd become
incrementally slower as it progresses).
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services