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 test index
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 test index as you described on my test box and tried the query and it used the new index. However, ORDER BY forum_id then last_post_tim
Adam Alkins <[EMAIL PROTECTED]> writes:
> SELECT t.topic_id
> FROM phpbb_topics AS t
> WHERE t.forum_id = 71
> AND t.topic_id NOT IN (205026, 29046,
> 144569, 59780, 187424,
> 138635, 184973, 170551, 22419, 1
Hi List,
I would like some insight from the experts here as to how I can alter
which index PostgreSQL is choosing to run a query.
First off, I'm running an active web forum (phpBB) with sometimes
hundreds of concurrent users. The query in question is one which pulls
the lists of topics in the for
