Re: Pre-allocate space in advance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 2005-11-01 at 11:17, 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."  
> 
> http://archives.postgresql.org/pgsql-interfaces/2001-01/msg00153.php
> 
> Thanks,

Ummm, that was a different Tom, wasn't it?

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux