Re: [ADMIN] Pre-allocate space in advance

2005-11-01 Thread Tomeh, Husam
Sorry about that. -- Husam -Original Message- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 01, 2005 9:25 AM To: Tomeh, Husam Cc: Tom Lane; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Pre-allocate space in advance On Tue, 2005-11-01 at 11:17, Tomeh

Re: [ADMIN] Pre-allocate space in advance

2005-11-01 Thread Jim C. Nasby
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

Re: [ADMIN] Pre-allocate space in advance

2005-11-01 Thread Scott Marlowe
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 t

Re: [ADMIN] Pre-allocate space in advance

2005-11-01 Thread Tomeh, Husam
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

Re: [ADMIN] Pre-allocate space in advance

2005-11-01 Thread Jim C. Nasby
On Mon, Oct 31, 2005 at 08:37:22PM -0500, Bruce Momjian wrote: > Jim C. Nasby wrote: > > There was recently discussion about changing how allocation happens in > > the future. I'm pretty sure it was started by Bruce Momjian on -hackers, > > but I can't find it in the archives now... > > I don't th

Re: [ADMIN] Pre-allocate space in advance

2005-10-31 Thread Bruce Momjian
Jim C. Nasby wrote: > There was recently discussion about changing how allocation happens in > the future. I'm pretty sure it was started by Bruce Momjian on -hackers, > but I can't find it in the archives now... I don't think is was me. If it was, it would be on the TODO list. -

Re: [ADMIN] Pre-allocate space in advance

2005-10-31 Thread Jim C. Nasby
There was recently discussion about changing how allocation happens in the future. I'm pretty sure it was started by Bruce Momjian on -hackers, but I can't find it in the archives now... On Mon, Oct 31, 2005 at 03:14:13PM -0800, Tomeh, Husam wrote: > I apologize for the wrong subject in a previous

[ADMIN] Pre-allocate space in advance

2005-10-31 Thread Tomeh, Husam
Title: Vacuum Verbose output I apologize for the wrong subject in a previous post. Here it is again:       My understanding that the current release of Postgres does not allow the DBA to pre-allocated space for the data files or tablespace in advance (as Oracle or SQL Server does). Am I corr