",
"auth_user"."first_name", "auth_user"."last_name", "auth_user"."email",
"auth_user"."password", "auth_user"."is_staff", "auth_user"."is_active",
"auth_user"."
On Fri, Mar 2, 2012 at 12:55 PM, Tomas Vondra wrote:
> On 2 Březen 2012, 13:45, Tyler Durden wrote:
> >>
> > Yes, but if I remove *U0."user_id" = 1 *will use the index:
>
> Which PostgreSQL version is that? Post EXPLAIN ANALYZE output for all
> thr
Hi,
On Fri, Mar 2, 2012 at 12:23 PM, Tomas Vondra wrote:
> Hi,
>
> On 2 Březen 2012, 13:12, Tyler Durden wrote:
> > Hi,
> > I can't figure out why query planner doesn't use the proper index, anyone
> > can help me?
> >
> > This query proper
Hi,
I can't figure out why query planner doesn't use the proper index, anyone
can help me?
This query properly uses indexes:
mydb=# EXPLAIN SELECT U0."object_id" FROM "activity_follow" U0 WHERE
(U0."content_type_id" = 3 AND U0."user_id" = 1);
QUERY PLAN
--
Hi,
I'm trying to migrate a database from an old posgresql 8.1 server to a
new one 8.3. I have the Postgis installed on that old database, that
is not used.
When I try to restore the database, several errors happens because of
the various links to libs of Postgis on the disk .
How do I dump the da
Ok, Thank all for the clarification.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Ok, my bad.
But why this happens:
# explain ANALYZE select id from table_name where id>20;
QUERY PLAN
Yes, either case happens the same.
I'm come recently from MySQL and it works in a different way.
I find strange that a simple SELECT COUNT(...) is so slow with only
700 000 records.
Has been a nightmare optimizing this tables/queries.
Sorry about this silly question, but I'm new to Posgresql.
Th
Hi,
I'm having some problems in performance in a simple select count(id)
from I have 700 000 records in one table, and when I do:
# explain select (id) from table_name;
-[ RECORD 1 ]
QUERY PLAN | Seq Scan on table_name (cost=0.0
