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;
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
Hi list,
I have the following table with millions of rows:
CREATE TABLE table1
(
col1 text,
col2 text,
col3 text,
col4 text,
col5 text,
col6 text
)
select col1 from table1 group by col1 limit 1;
select distinct on (col1) col1 from table1 limit 1;
select col1 from table1 group by co