Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group