Jean-Gerard, > The classic output from top (during all other index vacuum): > PID UID PRI NICE SIZE RES STATE WAIT TIME CPU COMMAND > 20461 503 14 0 13M 75M sleep semwai 5:27 2.05% postgres > > When backend hits the tsearch2 index, SIZE/RES grows until it reachs > 1GB, where I got the error. > PID UID PRI NICE SIZE RES STATE WAIT TIME CPU COMMAND > 20461 503 -5 0 765M 824M sleep biowai 4:26 33.20% postgres
OK, next thing to try is upgrading to 7.4.7. Since you have 7.4.2, this should be a straightforward binary replacement. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster