hi
Cud just guide me by explaining me the concepts required for increasing the database speed in Postgres 7.1(tuning the postgres).
Will a desktop at a remote place while inserting records into my database ,have any problems of time out/data loss if indexing is done thro' b tree(where in by default you can index upto 16 columns).
If so,what is the solution for this problem.Sometimes my coding requires to the extent of accessing 4 or more tables using suitable joins.Supposing I need to access four tables each of 1000 records.There is delay whle the main qury being processed because it is accessing 100010001000*1000 records.
So how to opimise this situation
Thx in advance for the support u gonna render
