From: | "Maksim Likharev" <mlikharev(at)aurigin(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | TO_CHAR SO SLOW??? |
Date: | 2003-06-24 01:08:19 |
Message-ID: | 56510AAEF435D240958D1CE8C6B1770A016D2D5B@mailc03.aurigin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I have some SQL function, just regular function selects data by using 4
joins nothing fancy,
but one thing pretty noticeable,
I have to display 3 different columns with same date formatted
differently,
here are 3 different snippets:
1. SELECT t.x,t.y,TO_CHAR(t.dt, 'DD/MM/YYYY')
FROM ( SELECT x, y, dt FROM .... ) AS t
...
2. SELECT t.x,t.y,TO_CHAR(t.dt, 'DD/MM/YYYY'), TO_CHAR(t.dt, 'Mon-YYYY')
FROM ( SELECT x, y, dt FROM .... ) AS t
..
3. SELECT t.x,t.y,TO_CHAR(t.dt, 'DD/MM/YYYY'), TO_CHAR(t.dt,
'Mon-YYYY'), TO_CHAR(t.dt, 'YYYY')
FROM ( SELECT x, y, dt FROM .... ) AS t
...
# 1: 15000 rows, I getting data for 130 sec
# 2: 15000 rows, I getting data for 160 sec
# 3: 15000 rows, I getting data for 220 sec
adding different fields into output change query time only marginally
but adding or removing to_char,
just heavily knocks performance.
is it TO_CHAR so slow??
P.S
Postgres 7.3
From | Date | Subject | |
---|---|---|---|
Next Message | deststar | 2003-06-24 01:16:38 | Re: [HACKERS] sa_family_t in cygwin compile of cvs + regression failure |
Previous Message | Bruce Momjian | 2003-06-23 23:59:48 | Re: [HACKERS] sa_family_t in cygwin compile of cvs + regression failure |