You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2015/04/21 11:56:59 UTC

[jira] [Closed] (CAY-2005) Improving generated DISTINCT performance on PostgreSQL

     [ https://issues.apache.org/jira/browse/CAY-2005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-2005.
--------------------------------
       Resolution: Fixed
    Fix Version/s: 4.0.M3

> Improving generated DISTINCT performance on PostgreSQL
> ------------------------------------------------------
>
>                 Key: CAY-2005
>                 URL: https://issues.apache.org/jira/browse/CAY-2005
>             Project: Cayenne
>          Issue Type: Improvement
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>             Fix For: 4.0.M3
>
>
> The problem is described here: http://markmail.org/message/j7alu33vfm7rjeba  Auto-generated DISTINCT keyword when translating SelectQuery results in slowdown of PostgreSQL queries (won't be surprised if this affects other DBs as well). Alternative PostgreSQL syntax "DISTINCT ON(id1, id2, ..)" solves the issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)