[GENERAL] how to find which tables required indexes in postgresql

hi,, please suggest if there is any way which i can find which tables need indexes in postgresql.

[GENERAL] how to create materialized view in postgresql 8.3

is it possible to created materialized view in postgresql 8.3 if yes please provide some sample.

[GENERAL] how to completely disable toasted table in postgresql and best practices to follow

Dear admin, please help me i want to completely disable Toasted tables in postgresql as per your suggestion i have used 9.0.13 but still toasted tables are getting created. also i want to know best practices and methods to clear such issues. kindly help Thanks & Regards, Z