| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Jose-Lopes Antunes" <Jose-Lopes(dot)Antunes(at)serpro(dot)gov(dot)br>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Table OraclexPostgresql |
| Date: | 2003-09-12 12:27:40 |
| Message-ID: | 200309121327.40600.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday 12 September 2003 12:41, Jose-Lopes Antunes wrote:
> Hi,
>
> I migrated one table from oracle to postgresql. I used a PgadminII. But
> the table allocated, in Oracle, 152MB and in Postgresql , after migration,
> the space was 568MB.
> Anybody help me?
Well, PG's files are named after the OID of the sytem object
(database/table/index) they hold. You can look this up in the system tables
or there is an oid2name tool in the contrib/ directory of the source distro.
You will also want to read Ch11 in the Administrator's guide.
You might want to try a VACUUM FULL of the table, and perhaps REINDEX to
reclaim any unused space.
HTH
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amin Schoeib | 2003-09-12 12:33:13 | Between(Interval of two dates) in Postgres |
| Previous Message | Richard Welty | 2003-09-12 12:06:48 | Re: library version problem, 7.3.2, php, redhat linux |