On Mon, Apr 18, 2011 at 7:14 AM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: > # REINDEX INDEX new_idx_userid; > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. > > > What else could be wrong? That's hardly enough information to guess, but since we're trying to guess, maybe your maintainance_mem went overboard and your server ran out of RAM. Or disk space. Aside from a bug, that's the only reason I can think for a pg backend to bail out like that. Well, the connection could have been cut off by other means (ie: someone tripped on the cable or something), but lets not dwell on those options. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance