R: [GENERAL] Queries on very big table

Поиск
Список
Период
Сортировка
От Job
Тема R: [GENERAL] Queries on very big table
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC1E5@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответ на [GENERAL] Queries on very big table  (Job <Job@colliniconsulting.it>)
Список pgsql-general
Дерево обсуждения
Hi,
 
i am trying "materialized views" in Postgresql 9.6.1.
Regarding Andy Calson suggestion:
 
>>I do very similar thing, log all my webstats to PG, but querying millions of rows is always going to be slow. I use a summary table.
 
They seems to work fine.
 
One question: the materialized view is stored into disk, not in ram. Is it right?
Does anyone use them with success on hundreds of millions of record?

Thank you again!
/F

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: [GENERAL] COPY: row is too big
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: [GENERAL] streaming replication protocol in Perl?