Re: [ADMIN] Pre-Allocate tablespace on disk

2010-11-19 Thread Florian Weimer
* 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

Re: [ADMIN] Pre-Allocate tablespace on disk

2010-11-19 Thread Steve Francis
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

[ADMIN] Building pl/plsh - Shell scripting from PG v9.0.1?

2010-11-19 Thread Lou Picciano
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