Re: COPY with high # of clients, partitioned table locking issues?

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Emanuel Calvo <postgres(dot)arg(at)gmail(dot)com>
Cc: "Strange, John W" <john(dot)w(dot)strange(at)jpmchase(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: COPY with high # of clients, partitioned table locking issues?
Date: 2011-03-31 16:25:41
Message-ID: AANLkTimCfdo6R9vytwm8bHNsj+cr0t_MU-8AgvojvgJ2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> But you are using stdin for COPY! The best way is use files.

I've never heard this before, and I don't see how reading from files
could possibly help. Can you clarify?
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Laszlo Nagy 2011-03-31 17:26:10 Why it is using/not using index scan?
Previous Message Bob Lunney 2011-03-31 14:54:25 Re: Slow deleting tables with foreign keys