From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | "josh(at)agliodbs(dot)com" <josh(at)agliodbs(dot)com>, Jan Wieck <JanWieck(at)Yahoo(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Single-file DBs WAS: Need concrete "Why Postgres |
Date: | 2003-08-23 13:31:27 |
Message-ID: | Pine.BSF.4.44.0308230927250.5470-100000@torgo.978.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers |
On Fri, 22 Aug 2003, Mike Mascari wrote:
> In addition to Jan's points, using a single pre-allocated file also
> reduces file descriptor consumption, although I don't know what the
> costs are regarding maintaining the LRU of file descriptors, the price
> of opens and closes, the price of having a high upper limit of file
> descriptors, etc.
>
another thought I had - I wonder how much fragmentation affects postgres
(and others). On Informix when you use "cooked files" it needs to
preallocate all the space. I figured part of it was to 1. make the file
seem more like a device 2. reduce fragmentation 3. guarantee that 2GB
"chunk" can never have an out of space issue.
On a dedicated pg box there is probably not much fragmentation (and thanks
to today's modern filesystems, it isn'ttoo big of a deal in any case)..
but it would still be interesting to have numbers..
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Anastasios Hatzis | 2003-08-23 15:02:29 | Surveys & Studies: FLOSS - Usage of Free/Libre Open Source Software (PostgreSQL, etc.) |
Previous Message | Hornyak Laszlo | 2003-08-23 10:57:36 | Re: [GENERAL] Need concrete "Why Postgres not MySQL" |
From | Date | Subject | |
---|---|---|---|
Next Message | Anastasios Hatzis | 2003-08-23 15:02:29 | Surveys & Studies: FLOSS - Usage of Free/Libre Open Source Software (PostgreSQL, etc.) |
Previous Message | Hornyak Laszlo | 2003-08-23 10:57:36 | Re: [GENERAL] Need concrete "Why Postgres not MySQL" |
From | Date | Subject | |
---|---|---|---|
Next Message | Anastasios Hatzis | 2003-08-23 15:02:29 | Surveys & Studies: FLOSS - Usage of Free/Libre Open Source Software (PostgreSQL, etc.) |
Previous Message | Hornyak Laszlo | 2003-08-23 10:57:36 | Re: [GENERAL] Need concrete "Why Postgres not MySQL" |