On 02/12/2015 11:38 PM, Kevin Grittner wrote:
If you go to the http://wcca.wicourts.gov/ web site, bring up any
case, and click the Court Record Events button, it will search a
table with hundreds of millions of rows. The table is not
partitioned, but has several indexes on it which are useful
Hello,
I've been away from postgres for several years, so please forgive me if
I forgot nearly everything:-)
I've just inherited a database collecting environmental data. There's a
background process continually inserting records (not so often, to say
the truth) and a web interface to query
On 02/13/2015 12:19 AM, Claudio Freire wrote:
I have a table with ~800M rows, wide ones, that runs reporting queries
quite efficiently (usually seconds).
Of course, the queries don't traverse the whole table. That wouldn't
be efficient. That's probably the key there, don't make you database