Hello, i have a "new" machine with following problem: postgres-7.4.13[7874]: [457-1] ERROR: could not open segment 1 of relation "data_server_id_idx" (target block 791807): No such file or directory
I my point of view it seems the same error as: http://archives.postgresql.org/pgsql-admin/2006-07/msg00028.php http://archives.postgresql.org/pgsql-admin/2006-07/msg00103.php The server is an HP DL 380 G4 with Battery Backup write cache. I am doing a lot of inserts. (Linux + Postgresql 7.4.13) I works correctly on an other server (Linux + Postgresl 7.4.10 , HP DL 380 G3 without Battery Backup Write Cache). Linux + Postgresql 7.4.10 + HP DL 380 G3 without Battery Backup Write Cache it takes about 4 hours Linux + Postgresql 7.4.13 + HP DL 380 G4 with Battery Backup Write Cache it takes about 15 minutes Amount of RAM is the same (4 GB ) both have ext3 Filesystems What could be the reason ? Postgresql 7.4.13 ? Configuration ? Linux Kernel (2.4.28 vs. 2.4.32) ? Backup Write Cache ? Hardware ? The first time it works correctly. Next day ist doesnt work. Any help is appreciated. regrads, -Franz ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
