Re: [PERFORM] Wrong plan or what ? - Mailing list pgsql-admin

From Josh Berkus
Subject Re: [PERFORM] Wrong plan or what ?
Date
Msg-id 200307221040.28653.josh@agliodbs.com
Whole thread Raw
In response to Wrong plan or what ?  ("Mendola Gaetano" <mendola@bigfoot.com>)
List pgsql-admin
Gaetano,

> SELECT * from user_logs where id_user in (
>  10943,   10942,   10934,   10927,   10910,  10909
> );
> [SNIPPED]

> Why the planner or the executor ( I don't know ) do not follow
> the same strategy ?

It is, actually, according to the query plan.

Can you post the EXPLAIN ANALYZE for the above query?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-admin by date:

Previous
From: "Srinivas Kotapally"
Date:
Subject: Using the /var/lib/pgsql/data directory in the absense of a backup for recovery
Next
From: Renney Thomas
Date:
Subject: Re: Replication/Failover/HA solution