Horton

Re: PostgreSQL win32 fragmentation issue

Gurjeet Singh <singh.gurjeet@gmail.com>

View thread View on postgr.es
From: "Gurjeet Singh" <singh.gurjeet@gmail.com>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Alvaro Herrera" <alvherre@commandprompt.com>, "Martijn van Oosterhout" <kleptog@svana.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2006-12-03T08:56:34Z
Lists: pgsql-hackers 
On 12/2/06, Joshua D. Drake <jd@commandprompt.com> wrote:
>
> On Sat, 2006-12-02 at 13:34 -0300, Alvaro Herrera wrote:
> > Joshua D. Drake wrote:
> >
> > > My concern is that this is over a single bench run. I could imagine
> that
> > > after a week or two weeks of stead PostgreSQL use, the IO would
> > > gradually get worse and worse.
> >
> > Well, we mostly do random reads (seek) all the time anyway, so is this
> > really a concern?
>
> Wouldn't it be for writes?


Also, huge index range scans can be badly affected by file level
fragmentation.

Regards,

-- 
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com