| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Henrik Steffen <steffen(at)city-map(dot)de> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: reindex vs. drop index , create index |
| Date: | 2003-02-21 06:40:43 |
| Message-ID: | 1045809643.582.435.camel@tokyo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)samurai(dot)com> || PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2003-02-21 06:42:53 | Re: How to drop all the sequences |
| Previous Message | Deepa | 2003-02-21 05:28:18 | Re: Creating index does not make any change in query plan. |