Dne 12.4.2011 09:33, Claudio Freire napsal(a):
I actually implemented a statistical system for measuring these kinds
of correlations.
It's complex, but it might be adaptable to pgsql. Furthermore, one of
the latest projects of mine was to replace the purely statistical
approach with SVCs.
On Wed, Apr 13, 2011 at 10:16 PM, Tomas Vondra t...@fuzzy.cz wrote:
You mean Support Vector Classifiers? Interesting idea, although I don't
see how to apply that to query planning, especially with non-numeric
inputs. Could you share more details on that statistical system and how
do you think
I actually implemented a statistical system for measuring these kinds
of correlations.
It's complex, but it might be adaptable to pgsql. Furthermore, one of
the latest projects of mine was to replace the purely statistical
approach with SVCs.
Too bad I won't be able to devote any time to that
@postgresql.org
Subject: Re: [PERFORM] Slow query postgres 8.3
Hi,
I am trying to tune a query that is taking too much time on a large
dataset (postgres 8.3).
Hi, run ANALYZE on the tables used in the query - the stats are very off, so
the db chooses a really bad execution plan.
Tomas
Anne Rosset aros...@collab.net wrote:
- Index Scan using role_oper_obj_oper
on role_operation (cost=0.00..93.20 rows=45 width=9) (actual
time=0.236..71.291 rows=6108 loops=1)
Index Cond:
(((object_type_id)::text =
Hi,
I am trying to tune a query that is taking too much time on a large
dataset (postgres 8.3).
Hi, run ANALYZE on the tables used in the query - the stats are very off,
so the db chooses a really bad execution plan.
Tomas
--
Sent via pgsql-performance mailing list
Hi,
I am trying to tune a query that is taking too much time on a large
dataset (postgres 8.3).
SELECT DISTINCT
role_user.project_id AS projectId,
sfuser.username AS adminUsername,
sfuser.full_name AS adminFullName
FROM
role_operation role_operation,