From: | Jalisson Mello <jalissonmeneses(at)hotmail(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Copy to Csv file extremely slow |
Date: | 2013-05-30 17:48:20 |
Message-ID: | BAY175-W1987D1F23E3C9F7C1EC6D2A6910@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi, I´m using the copy command to generate a csv file, but the generation its extremely slow in a production server. In our test's server this copy takes 20 minutes but in a production server this takes 2 days.
The database that i used to the tests is a copy of the production database.
The machines are totaly differents. Test Server is a simple Intel core 2 duo 2.8 ghz with 8 GB Ram and Production Server has 2 xeon 2.8 ghz with 24 GB RAM.
Before the tests we ran vacuum and closed all another connections.
The query takes 19 minutes and file generation less than 1 minute to create a file with 473 MB in the tests server. In Production server the query runs in the same 19 minutes, but file generation 2 days.
I'm running postgresql 9.0 on CentOS 6.3 on both machines.
Any idea about this big difference.
Thanks , and sorry by my english.
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2013-05-30 19:54:51 | Re: Copy to Csv file extremely slow |
Previous Message | Birchall, Austen | 2013-05-29 16:20:16 | Re: |