D]>
Sent: Wednesday, July 02, 2003 8:19 PM
Subject: [GENERAL] Forcing a query plan
I have a number of very common queries that the optimizer plans a very
inefficient plan for. I am using postgres 7.2.3. I vacuum hourly. I'm
wondering what I can do to make the queries faster.
Here are the re
I have a number of very common queries that the
optimizer plans a very inefficient plan for. I am using postgres 7.2.3. I vacuum
hourly. I'm wondering what I can do to make the queries faster.
Here are the relevant tables:
create table image( imageid
integer not null, /* The imag
