From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Jesper Krogh <jesper(at)krogh(dot)cc> |
Cc: | Divakar Singh <dpsmails(at)yahoo(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Postgres insert performance and storage requirement compared to Oracle |
Date: | 2010-10-28 13:13:22 |
Message-ID: | AANLkTinBtTQ2mTPvA3n_yF=rLNfeK2RRW7FGOHqfWmv_@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
On Wed, Oct 27, 2010 at 3:47 PM, Jesper Krogh <jesper(at)krogh(dot)cc> wrote:
> On 2010-10-27 20:51, Merlin Moncure wrote:
>
>>> Yes, I am quite aware of how the o/s page cache works. All else being
>>> equal, I more compact database obviously would be preferred. However
>>> 'all else' is not necessarily equal. I can mount my database on bzip
>>> volume, that must make it faster, right? wrong. I understand the
>>> postgres storage architecture pretty well, and the low hanging fruit
>>> having been grabbed further layout compression is only going to come
>>> as a result of tradeoffs.
>>>
>
> Or configureabillity.. Not directly related to overall space consumption
> but I have been working on a patch that would make TOAST* kick in
> earlier in the process, giving a "slimmer" main table with visibillity
> information
> and simple columns and moving larger colums more aggressively to TOAST.
Do you have any benchmarks supporting if/when such a change would be beneficial?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-28 13:36:57 | Re: plan time of MASSIVE partitioning ... |
Previous Message | Pavel Stehule | 2010-10-28 12:55:40 | revision of todo: NULL for ROW variables |
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth Marshall | 2010-10-28 13:34:36 | Re: Select count(*), the sequel |
Previous Message | André Volpato | 2010-10-28 12:33:07 | Re: AIX slow buffer reads |