Re: The same query is too slow in some time of execution - Mailing list pgsql-general

From DrakoRod
Subject Re: The same query is too slow in some time of execution
Date
Msg-id 1490371028589-5951841.post@n3.nabble.com
Whole thread Raw
In response to Re: [GENERAL] The same query is too slow in some time of execution  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
You're right, I'm sorry.

At the moment, we review the schema for tables and indexes and decided
redesigned. I detected a loop in the join, because we only have a integer
sequencial like PK  and no composite keys in the tables. I think that is the
mainly problem.

Thanks!



-----
Dame un poco de fe, eso me bastará.
Rozvo Ware Solutions
--
View this message in context:
http://www.postgresql-archive.org/The-same-query-is-too-slow-in-some-time-of-execution-tp5951060p5951841.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Combining INSERT with DELETE RETURNING
Next
From: Yuri Budilov
Date:
Subject: browser interface to forums please?