5 Jul
2011
5 Jul
'11
4:59 p.m.
On 07/05/11 7:10 AM, Charles Polisher wrote:
In general and with some simplifiying assumptions, a database consists of statically pre-allocated files. The process of extending the files happens at birth. The relative speed over the lifetime of the database is dominated by raw I/O, not by extending the files.
thats not even remotely true of many databases. PostgreSQL, for example, the files are extended as they are updated/inserted, as are the WAL files.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast