Queries with timestamps
| От | Arnau |
|---|---|
| Тема | Queries with timestamps |
| Дата | |
| Msg-id | 029701c3e04b$ea608930$3c0aa8c0@iberica.andromeiberica.com обсуждение исходный текст |
| Ответы |
Re: Queries with timestamps
|
| Список | pgsql-performance |
Hi all,
I'm quite newbie in SQL and I have a performance problem. I have the
following table (with some extra fields) and without any index:
CREATE TABLE STATISTICS
(
STATISTIC_ID NUMERIC(10) NOT NULL DEFAULT
nextval('STATISTIC_ID_SEQ')
CONSTRAINT pk_st_statistic_id
PRIMARY KEY,
TIMESTAMP_IN TIMESTAMP,
VALUE NUMERIC(10)
);
The queries on this table are mainly related with the timestamp field,
e.g.:
select * from statistics where time::date < current_date - interval
'1 month';
As the number of rows grows the time needed to execute this query takes
longer. What'd I should do improve the performance of this query?
Thank you very much
--
Arnau
В списке pgsql-performance по дате отправления: