Обсуждение: making postgres DB stable, efficient and secure
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.
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.
Thanks,
~Jas
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.
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.
Thanks,
~Jas
-----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-----
On Thu, 2007-03-22 at 16:59 -0400, 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. > > 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. > (1) Run it on a stable OS (2) Disable write cache on your disks, and make *sure* it's disabled The rest of your question is quite open-ended. Start with the default configuration, read the documentation, experiment on a separate box you don't care about, and you're on the right track. Regards, Jeff Davis