RE: [SQL] index file's growing big

Well, you're absolutely right:) Thanks.
What I would like to know is what are those [table_name].D, [table_name].D2,
[table_name].T, [table_name].T2, [table_name].TT files?
They seem to be some dump files as if pg_dump would create them as a dump
copy when I run it to create a dump to somewhere else..

Zoltan Sebestyen
NETvisor Kft
1111 Muegyetem rkpt.9. Fsz.8.
Budapest, Hungary.
Fax: (+36-1) 463-4396
Tel: (+36-1) 463-4392, 463-4393

"Programming is an art, not a science,              and not all programmers are Picassos."

-----Original Message-----
From: Ross J. Reedstrom [mailto:reedstrm@wallace.ece.rice.edu]
Sent: Tuesday, March 07, 2000 4:22 PM
To: Sebestyén Zoltán
Subject: Re: [SQL] index file's growing big

...

Seriously, try:

drop index foo_idx;
create index foo_idx on foo_table (bar_field);

That should save you a _lot_ of time relative to a complete dump and
restore.

Ross