Re: [PERFORM] cont. how to optimize postgres 8.1

2006-09-29 Thread Tom Lane
[EMAIL PROTECTED] writes: > How do I optimize postgres8.1? 8 msec for a five-way join doesn't sound out of line to me. What were you expecting? regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Us

[PERFORM] cont. how to optimize postgres 8.1

2006-09-29 Thread gurkan
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