Sorry,
is there a way to tell Postgres which index to use when a query is
issued in 7.4.2?
PostgreSQL adjusts usage through global parameters, statistics, and periodic
ANALYZE. Please post an EXPLAIN ANALYZE (not just EXPLAIN) for your query
and people on this list can help you with your spec
comparison, so Postgres does its
best. And I don't constantly want to switch on and off the hashjoin and
mergejoin.
Regards,
Silke Trissl
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi,
I came across a very intriguing thing:
I had to join two tables and in both tables I wanted to restrict the
result set by some (text/varchar) attributes.
Here is an example:
Table "item" # 147 000 entries
Column | Type | Modifiers
---+-
