Re: reindex vs. drop index , create index - Mailing list pgsql-general

From Neil Conway
Subject Re: reindex vs. drop index , create index
Date
Msg-id 1045809643.582.435.camel@tokyo
Whole thread Raw
In response to reindex vs. drop index , create index  ("Henrik Steffen" <steffen@city-map.de>)
Responses Re: reindex vs. drop index , create index
List pgsql-general
On Thu, 2003-02-20 at 12:03, Henrik Steffen wrote:
> a few weeks ago I turned to REINDEXing my tables instead of DROPping and
> reCREATEing them.
>
> now, however, I again have problems when VACUUMing or REINDEXing these
> tables. Postgres states that the connection has been lost etc.

Can you provide the exact error message, as well as the version of
PostgreSQL you're using and any relevant OS version details.

Also, it sounds like PostgreSQL might be dumping core. If that's the
case, providing a backtrace from the core file (using gdb) would be
helpful. It would be especially helpful if you could recompile
PostgreSQL with debugging symbols (./configure --enable-debug) and get a
backtrace after that.

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC




pgsql-general by date:

Previous
From: Deepa
Date:
Subject: Re: Creating index does not make any change in query plan.
Next
From: Neil Conway
Date:
Subject: Re: How to drop all the sequences