Skip site navigation (1) Skip section navigation (2)

Re: Pre-allocate space in advance

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Scott Marlowe <smarlowe(at)g2switchworks(dot)com>,pgsql-admin(at)postgresql(dot)org
Subject: Re: Pre-allocate space in advance
Date: 2005-11-01 17:41:25
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
On Tue, Nov 01, 2005 at 09:17:46AM -0800, Tomeh, Husam wrote:
> I don't have any numbers; and it may be an misconception as you pointed
> out that's out there among Oracle DBAs that need to be re-visited again.
> Tom, could you also explain what you meant in a previous post I found
> during my research on this issue, which I may have misunderstood it: "I
> actually wish that Postgres would preallocate a lot of blocks in advance
> (ie. 100 x 8KB). That would probably improve performance, as it would
> not have to keep re-extending the file."  

Wrong Tom.
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software    work: 512-231-6117
vcard:       cell: 512-569-9461

In response to

pgsql-admin by date

Next:From: Jim C. NasbyDate: 2005-11-01 17:43:12
Subject: Re: UNIQUE KEY with null value...
Previous:From: Tomeh, HusamDate: 2005-11-01 17:38:48
Subject: Re: Pre-allocate space in advance

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group