V
My query is
select EXTRACT(MONTH FROM M.fecha) as ho,count(*) as tot from correo M
where EXTRACT(YEAR FROM M.fecha)='2004' group by EXTRACT(MONTH FROM
M.fecha);
When I executed a EXPLAIN ANALIZE, I hace the following Answer
Aggregate (cost=122439.31..122558.36 rows=2381 width=4) (actual
time
--- Vida Luz <[EMAIL PROTECTED]> escribió:
> Hi all
>
> I have a table in y database that have 8,000,000 of
> rows, when I execut a
> query on this table, the answuer is very slow.
>
> I have a index in this table by datem, my table is
>
> Column | Type| Modifiers
> -
Hi all
I have a table in y database that have 8,000,000 of rows, when I execut a
query on this table, the answuer is very slow.
I have a index in this table by datem, my table is
Column | Type| Modifiers
-+---+---
nombre | charac
Please:
* I need a example of function where return a consult
(temp table)?
* How I could make a function or anything that give me
the machine name that is connet remote to me
postgresql server?
Thank you very match
_
Do You Yahoo!?
Obte
