Lutz Fischer <lfischer@xxxxxxxxxxxxxxxxxx> writes: > I have currently some trouble with inserts into a table > If I run only [ the select part ] > it returns 200620 rows in 170649 ms ( thats just under 3 minutes). I > stopped the actual insert after about 8h. It should not take 8h to insert 200k rows on any machine made this century. Frankly, I'm wondering if the insert is doing anything at all, or is blocked on a lock somewhere. You say there's no concurrent activity, but how hard did you look? Did you check that, say, the physical disk file for the table is growing? > I am running postgresql 9.2 on a windows 2008 R2 server with 256 GB and > the database is on something like a raid 1+0 (actually a raid1e) > consisting of 3x4TB disks (limit of what could easily be fitted into the > server). A different line of thought is that there's something seriously broken about the raid configuration. Have you tried basic disk-speed benchmarks? (Perhaps there's an equivalent of bonnie++ for windows.) regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
