[PERFORM] cont. how to optimize postgres 8.1

Hi, How do I optimize postgres8.1? I have 'vacuum full analyze' I have posted output of 'explain analyze select ..' I have created some indexes I am running Mixed-Mode server,4GB ram running FC5(64bit), postgresql 8.1 AND My configs are;(Are these good number?) --- kernel.shmma

[PERFORM] how to optimize postgres 8.1

Hi, I am working on datamigration from older version of informix to postgres 8.1 I need to increase performance on postgres, since informix(older version,older hardware, little bigger DB data) is 4-5 times faster than postgres8.1 (new hardware, less DB data) My readings from Internet lead to me b