-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/22/07 15:59, Jasbinder Singh Bali wrote: > Hi, > I'm done with my database design and almost got it working (with all > triggers and functions) pefectly. > Now, i need to see how can I make my DB stable, efficient and secure.
Your database is not stable???????? You host it on Windows? > > I wanted to know how should I go about it as far as postgres is concerned > What are the best practices is this regard. > > Any kind of help would be higly appreciated. Start with what you do on any database: GRANT/REVOKE and creating indexes that match your queries, updates & deletes without impact inserts. Next is buffer sizing. http://www.postgresql.org/docs/8.2/interactive/ What version are you running? > > Thanks, > ~Jas -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGAvOhS9HxQb37XmcRAmHNAKCqpB/mTInSjjRmOR3ql+rKXZdW5ACgo208 f6RLxC9ypHHqcMqNAxylNF8= =tsED -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
