queries on huge tables

Поиск
Список
Период
Сортировка
От Lending, Rune
Тема queries on huge tables
Дата
Msg-id A177ACC01D78D4118FC100508BAE3F7A0207CE10@TELECOMMAIL
обсуждение исходный текст
Ответы Re: queries on huge tables  (Mike Rylander <mrylander@gmail.com>)
Список pgsql-performance
Hello all.
 
I am having a couple of tables with couple of hundre millions records in them. The tables contains a timestamp column.
I am almost always interested in getting datas from a specific day or month. Each day contains aprox. 400.000 entries.
 
When I do such queries as " select ... from archive where m_date between '2005-01-01' and '2005-02-01' group by ... " and so on.
It takes very long. I am having indexes that kicks in, but still it takes sometime.
 
I have splitted the archive table in smaller monthly tables, it then goes a lot faster, but not fast enough.
 
I know simular systems that uses Oracle and gains a lot on performance because of the partioning. That kind of anoyes me a bit :)
 
Does anyone of you have some good ideas on how speed up  such queries on huge tables?
 
regards
rune
 
 
 
 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ales Vojacek
Дата:
Сообщение: TOP 10 SQL commands and more
Следующее
От: Alexander Ranaldi
Дата:
Сообщение: Building a DB with performance in mind