| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Alvaro Herrera <alvherre(at)atentus(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Manfred Koizar <mkoi-pg(at)aon(dot)at>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Reduce heap tuple header size |
| Date: | 2002-06-22 20:56:29 |
| Message-ID: | 4451.1024779389@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> So it saves less than 3% disk space at the cost of about 9% performance
> loss.
>
> Uh ... isn't more TPS better?
> 9%, that is a dramatic difference.
Yup. I'm suspicious of it --- if the database is 3% smaller then I'd
believe a 3% performance gain from reduction of I/O, but I don't see
where 9% comes from.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-22 21:45:09 | Re: Hash and bools |
| Previous Message | Robert Kernell | 2002-06-22 16:48:12 | computer for todo list |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-06-22 21:17:36 | Re: ODBC Patch to prevent setting of KSQO on 7.3+ servers |
| Previous Message | Dave Page | 2002-06-22 19:56:20 | Re: ODBC Patch to prevent setting of KSQO on 7.3+ servers |