DB novice questions
От | Isabella Ghiurea |
---|---|
Тема | DB novice questions |
Дата | |
Msg-id | 48EF92DC.8030308@nrc-cnrc.gc.ca обсуждение исходный текст |
Ответы |
Re: DB novice questions
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: