Message-ID: <48EF92DC.8030308@nrc-cnrc.gc.ca>
Date: Fri, 10 Oct 2008 10:37:32 -0700
From: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca
Organization: CADC -NRC
User-Agent: Thunderbird 1.5.0.12 (X11/20070530)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: DB novice questions
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hello Gurus,
I'm new to Postgress world and before start creating my first database 
for test.
I have some questions, beware  I have  experience with other RDBMS.

1- when  issue create db , is there a option to specify the database 
page size ? what's the default ? ( don't see any comments in docs)
2-any basic tips for cfg to achieve some reliable  database I/O 
performance , my  first toughts are to create at least 2 additional 
table spaces: one for indexes and one for data.
when creating the db , how can I specify a separate table space for :s 
ystem catalog , data and indexes ?( any special syntax , can't find to 
many examples in PG docs)
3- what is   the best practice to use ad owner for a db , if I create 
the db as user: postgress   , any implication for not using this  user 
as owner of all db's ?
 thank you
Isabella