Re: [PERFORM] Index Choice Problem

Nevermind the reply, blonde moment on the ordering...This works :)ThanksOn 2/18/06, Adam Alkins < [EMAIL PROTECTED]> wrote:Unfortunately I'm using 8.0.4 and this is for a government website, I only get so many maintenance windows. Is this the only workaround for this issue? I did make a

Re: [PERFORM] Index Choice Problem

then last_post_time is simply not the intended sorting order. (Though I'm considering just SELECTing the topic_last_post_time field and resorting the results in the script if this is the only workaround). - AdamOn 2/18/06, Tom Lane <[EMAIL PROTECTED]> wrote: Adam Alkins <[EMAIL PROTECTED]> writ

[PERFORM] Index Choice Problem

index to use in the query. I'm think adding logic in my script depending on which forum_id is used (since I can hard code in my scripts which are the popular forums) and tell the planner to use a specific index first? Secondly, why in the last output did it opt to do a sequentia

Re: [PERFORM] 100 simultaneous connections, critical limit?

with persistent connections. The cost of pg_connect is minimal, pg_pconnect is not a viable solution IMHO. Connections are rarely actually reused. -- Adam Alkins http://www.rasadam.com ---(end of broadcast)--- TIP 3: if posting/reading through U