Postgres Pro
Downloads
Home   >   mailing lists

R: [GENERAL] Queries on very big table - Mailing list pgsql-general

From Job
Subject R: [GENERAL] Queries on very big table
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC1E5@W2008DC01.ColliniConsulting.lan
Whole thread Raw
In response to [GENERAL] Queries on very big table  (Job <Job@colliniconsulting.it>)
List pgsql-general
Tree view
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: [GENERAL] COPY: row is too big
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: [GENERAL] streaming replication protocol in Perl?