RE: [SQL] index file's growing big

From: zoltan(dot)sebestyen(at)netvisor(dot)hu
To: reedstrm(at)wallace(dot)ece(dot)rice(dot)edu
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: RE: [SQL] index file's growing big
Date: 2000-03-07 16:13:35
Message-ID: 617185BB0AA2D111872400105AD899AD1490E9@netvisorpdc.intranet.netvisor.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)wallace(dot)ece(dot)rice(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Mitch Vincent 2000-03-07 16:38:17 Re: [SQL] postgreSQL vs mySQL
Previous Message Trurl McByte 2000-03-07 15:44:52 Re: [SQL] VarChar(n)