| From: | Mario Splivalo <mario(dot)splivalo(at)megafon(dot)hr> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Inserting 'large' amounts of data |
| Date: | 2009-08-26 16:28:44 |
| Message-ID: | 4A9562BC.8030804@megafon.hr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I have a web application which allows users to upload a lot of phone
numbers. I need to store those numbers to a database. Usualy, one would
upload around 70k-100k of records, totaling around 2 MB in size.
I'm using tomcat as an application server, and JDBC to connect to pg8.3
database.
I will have around 20-50 concurent users in peek hours, and even that is
quite overestimated.
I could create the temporary file on the filesystem where database
cluster is located and then execute COPY mytable FROM
'/tmp/upload-data/uuidofsomesort.csv' WITH CSV', but the 'problem' is
that database server and tomcat reside on different physical machines.
What would one recommend as the best way to insert those data?
Mario
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2009-08-26 17:17:11 | Re: Inserting 'large' amounts of data |
| Previous Message | Maciek Sakrejda | 2009-08-26 09:01:51 | Re: PGStream synchronization |