On Tue, 2010-07-13 at 20:33 +0800, Craig Ringer wrote: > That's a write rate of 34MB/min, or half a meg a second. Not pretty. > > Where's the load during the COPY? Mostly CPU? Or mostly disk I/O? > > Are you writing the output to the same disk the database is on? (Not > that it should make this much difference). > > > 3) Find a solution when the file size become > 1GB > > That's going to be interesting.
> Do you really need to store whole XML documents this size in the > database, rather than broken up into structures that can be worked with > usefully in the database? If so, PostgreSQL might not be your best choice. > This is solution seems wrong as a whole. A file that size has no business inside PostgreSQL. If he "really" needs a DB API to it, have a point to the filesystem where the file lives and write a pl-/perl/java/python/php/ruby function to slurp the XML from the filesystem and hand it off. JD > -- > Craig Ringer > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
