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
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) |