| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Maximum table size |
| Date: | 2003-09-09 14:56:52 |
| Message-ID: | 20030909145652.GD18350@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Sep 09, 2003 at 02:04:43AM -0400, Tom Lane wrote:
> It's a holdover. As to how certain we are that all the
> signed-vs-unsigned bugs are fixed, who have you heard from running a
> greater-than-16Tb table? And how often have they done CLUSTER, REINDEX,
> or even VACUUM FULL on it? AFAIK we have zero field experience to
> justify promising that it works.
BTW, I applied CLUSTER to a 1.6 GB tables a couple of days ago for the
first time and man did it take a long time. The current code is
way too inefficient for rebuilding the table. Maybe another approach
should be used. I don't think clustering a 16 TB table is a serious
proposition.
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
Si no sabes adonde vas, es muy probable que acabes en otra parte.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | luke | 2003-09-09 15:08:12 | libpq++ |
| Previous Message | Manfred Koizar | 2003-09-09 14:56:20 | Re: plpgsql doesn't coerce boolean expressions to boolean |