import performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,

I'm trying to work out why my 8.1 system is slower than my 7.4 system for importing data.

The import is a lot of "insert into" commands - it's a converted database from another system so I can't change it to copy commands.


My uncommented config options:


autovacuum = off

bgwriter_all_maxpages = 15
bgwriter_all_percent = 10.0
bgwriter_delay = 2000
bgwriter_lru_maxpages = 10
bgwriter_lru_percent = 5.0

checkpoint_segments = 10

commit_delay = 100000
commit_siblings = 500

temp_buffers = 500

wal_buffers = 16

max_connections = 16

shared_buffers = 256


(I was playing around with the bgwriter stuff to see if it made any differences, so I could be making it worse).

It's a pretty small machine - 2.6GHz with 512M RAM.

My main concern is 7.4 on a smaller machine with less memory is faster to import this data.


Suggestions on what I need to do would be fantastic, thanks!

--
Postgresql & php tutorials
http://www.designmagick.com/


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux