| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Chris Gamache <cgg007(at)yahoo(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Full Text Indexing... |
| Date: | 2002-02-13 01:09:36 |
| Message-ID: | 20020212170545.U99059-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 12 Feb 2002, Chris Gamache wrote:
> Computing the amount of disk space it would take to house the full text index
> on one of the fields in my database:
>
> 36 bytes: each row header (approximate)
> + 53 bytes Varchar(53)
> + 8 bytes: oid field
> + 4 bytes: pointer on page to tuple
> ----------------------------------------
> 101 bytes per row
Well, varchar(53) should be I think 4 bytes + length of string
(4-57 bytes, not a constant 53), but that's likely to be no more
than a 25-30% reduction overall (depends on your average string lengths).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2002-02-13 01:21:14 | Re: Mail archives problems |
| Previous Message | Tigran | 2002-02-13 01:05:52 | Re: Mail archives problems |