| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: making postgres DB stable, efficient and secure |
| Date: | 2007-03-22 21:22:42 |
| Message-ID: | 4602F3A2.3070006@cox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kev | 2007-03-22 21:58:15 | cutting out the middleperl |
| Previous Message | Jasbinder Singh Bali | 2007-03-22 20:59:58 | making postgres DB stable, efficient and secure |