Re: [HACKERS] Can postgres create a file with physically continuous blocks.

2010-12-21 Thread Heikki Linnakangas
On 22.12.2010 09:25, Rob Wultsch wrote: On Wed, Dec 22, 2010 at 12:15 AM, Heikki Linnakangas wrote: Hmm, innodb_autoextend_increment seems more like what we're discussing here (http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_autoextend_increment). If I'm reading tha

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

2010-12-21 Thread Rob Wultsch
On Wed, Dec 22, 2010 at 12:15 AM, Heikki Linnakangas wrote: > On 22.12.2010 03:45, Rob Wultsch wrote: >> >> On Tue, Dec 21, 2010 at 4:49 AM, Robert Haas >>  wrote: >>> >>> On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasby  wrote: On Dec 19, 2010, at 1:10 AM, flyusa2010 fly wrote: > > Do

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

2010-12-21 Thread Heikki Linnakangas
On 22.12.2010 03:45, Rob Wultsch wrote: On Tue, Dec 21, 2010 at 4:49 AM, Robert Haas wrote: On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasby wrote: On Dec 19, 2010, at 1:10 AM, flyusa2010 fly wrote: Does postgres make an effort to create a file with physically continuous blocks? AFAIK all files

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

2010-12-21 Thread Rob Wultsch
On Tue, Dec 21, 2010 at 4:49 AM, Robert Haas wrote: > On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasby wrote: >> On Dec 19, 2010, at 1:10 AM, flyusa2010 fly wrote: >>> Does postgres make an effort to create a file with physically continuous >>> blocks? >> >> AFAIK all files are expanded as needed. I d

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

2010-12-21 Thread Robert Haas
On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasby wrote: > On Dec 19, 2010, at 1:10 AM, flyusa2010 fly wrote: >> Does postgres make an effort to create a file with physically continuous >> blocks? > > AFAIK all files are expanded as needed. I don't think there's any flags you > can pass to the filesyst

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

2010-12-19 Thread Jim Nasby
On Dec 19, 2010, at 1:10 AM, flyusa2010 fly wrote: > Does postgres make an effort to create a file with physically continuous > blocks? AFAIK all files are expanded as needed. I don't think there's any flags you can pass to the filesystem to tell it "this file will eventually be 1GB in size".