Could you provide the output of EXPLAIN ANALYZE with your query?
On Fri, Jan 9, 2009 at 7:06 PM, Reg Me Please wrote:
> Hi.
>
> For an INNER JOINed query, EXPLAIN says that a "nested loop" is responsible
> for the big part of the time needed to run.
>
> The 2 tables JOINed are:
>
> T1: multi-mill
names (
record_id INTEGER REFERENCES records,
position INTEGER NOT NULL,
name TEXT NOT NULL,
UNIQUE (record_id, position)
);
This way you can easily search by doing something like
SELECT position FROM names
WHERE name = 'TEST';
Regards,
Victor Nawothnig
--
Sent via pgsql-general m
