[PERFORM] Providing user based previleges to Postgres DB

Hi All, Currently in one of the projects we want to restrict the unauthorized users to the Postgres DB.Here we are using Postgres version 8.2.0 Can anybody tell me how can I provide the user based previleges to the Postgres DB so that, we can restrict the unauthorized users as

[PERFORM] Table Inheritence and Partioning

Hi, We are having 3 tables; 1. persons <-- Base table and no data will be inserted in this table. 2. Person1 <-- Inherited table from persons all data will be inserted in this table. 3. PersonalInfo <-- which is storing all personal information of the persons and is having the foreign key rel

Re: [PERFORM] Caching in PostgreSQL

Hi Heikki Linnakangas, Thanks for yoru kind response. We were looking on how to improve the performance of our application which is using PostgreSQL as backend.If postgreSQL is supporting data page caching in the shared memory then we wanted to design our application to read

[PERFORM] Caching in PostgreSQL

Hi, Can anybody tell me how can I implement data Caching in the shared memory using PostgreSQL. For one of the projects we are using Postgres version 8.0.3 and were planning to support table partitioning in order to improve the DB query/update performance but, it will be very m