Skip site navigation (1) Skip section navigation (2)

Distinct + Limit

From: Francois Deliege <fdeliege(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Distinct + Limit
Date: 2012-03-27 20:37:51
Message-ID: 5833589.541.1332880671745.JavaMail.geo-discussion-forums@pbbnv8 (view raw or flat)
Thread:
Lists: pgsql-performance
Hi group,

I have the following table with millions of rows

CREATE TABLE table1
(
  col1 text,
col1 text,
  doc text
)

select col1 from table1 group by col1 limit 2;
select distinct on (col1) col1 from table1 limit 2;


Responses

pgsql-performance by date

Next:From: Dave CrookeDate: 2012-03-27 20:40:32
Subject: Re: Linux machine aggressively clearing cache
Previous:From: Claudio FreireDate: 2012-03-27 20:10:27
Subject: Re: Linux machine aggressively clearing cache

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group