* Chris Ruprecht:
> Other database that I have worked with before and that I'm still
> working with, allow you to pre-allocate disk space so you get huge
> chunks of contiguous space at one, which has major impacts on
> database performance.
PostgreSQL's write patterns do not trigger significant
Not only that, but if your "disk" is really a bunch of disks behind
a hardware RAID controller, or SAN, or iSCSI or NFS server - what is
contiguous for the OS may not be contiguous on the physical drives
(and vice versa).
Which is why performance can (but may not) impro
PG Wizards:
I wonder if any of you has had luck building plpgsh on a v9.0.1 build of
PostgreSQL?
Platform is x86 openIndiana. Perhaps I'm the first?
This simple configure seems to work:
# ./configure prefix=/usr/local/pgsql/901
PG_CONFIG=/usr/local/pgsql/901/bin/pg_config
But build