-----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-----