Re: Add LIMIT option to COPY FROM

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add LIMIT option to COPY FROM
Date: 2026-02-03 14:41:54
Message-ID: 1226620.1770129714@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Shinya Kato <shinya11(dot)kato(at)gmail(dot)com> writes:
> I'd like to propose adding a LIMIT option to COPY FROM, which limits
> the number of rows to load.

Do we really need this? Each random feature we load onto COPY
slows it down for everybody.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-02-03 14:45:49 Re: Remove unused isCommit parameter from AtEOXact_LocalBuffers
Previous Message Andres Freund 2026-02-03 14:41:51 Re: More speedups for tuple deformation