| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
| Cc: | t-ishii(at)sra(dot)co(dot)jp, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Problems with >2GB tables on Linux 2.0 |
| Date: | 1999-03-17 04:45:35 |
| Message-ID: | 199903170445.NAA09312@srapc451.sra.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>Just a question. Does your patch let vacuum handle segmented tables?
>--
>Tatsuo Ishii
>It simply reduces the size of each segment from 2Gb to 1Gb. The problem
>was that some OS's (Linux in my case) don't like files exactly 2Gb in
>size. I don't know how vacuum interacts with the storage manager, but in
>theory it should be transparent.
Ok. So we still have following problem:
test=> vacuum smallcat;
NOTICE: Can't truncate multi-segments relation smallcat
VACUUM
Maybe this should be added to TODO if it's not already there.
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan Bradetich | 1999-03-17 04:49:40 | Re: [HACKERS] Sequences.... |
| Previous Message | Tatsuo Ishii | 1999-03-17 02:08:23 | Re: [HACKERS] Re: Developers Globe (FINAL) |