Re: SQL performance issue with PostgreSQL compared to MySQL - Mailing list pgsql-sql

From Tom Lane
Subject Re: SQL performance issue with PostgreSQL compared to MySQL
Date
Msg-id 4193.1024496331@sss.pgh.pa.us
Whole thread Raw
In response to SQL performance issue with PostgreSQL compared to MySQL  (Jeff Self <jself@nngov.com>)
Responses Re: SQL performance issue with PostgreSQL compared to MySQL
List pgsql-sql
Jeff Self <jself@nngov.com> writes:
> if it's too OT, let me know, and I'll stop. The query "SELECT authuser,
> SUM(bytes) AS traffic FROM logfile GROUP BY authuser ORDER BY traffic"
> [is slow]

What datatype are the columns used in the query?  And what PG version
are we talking about?
        regards, tom lane


pgsql-sql by date:

Previous
From: Masaru Sugawara
Date:
Subject: Re: Joining three data sources.
Next
From: "Josh Berkus"
Date:
Subject: Re: SQL performance issue with PostgreSQL compared to