| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | "Tomeh, Husam" <htomeh(at)firstam(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Pre-allocate space in advance |
| Date: | 2005-11-01 17:25:06 |
| Message-ID: | 1130865905.15018.49.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Faulhaber | 2005-11-01 17:28:18 | Re: UNIQUE KEY with null value... |
| Previous Message | Tomeh, Husam | 2005-11-01 17:17:46 | Re: Pre-allocate space in advance |