Re: making postgres DB stable, efficient and secure

[Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>]

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