Re: [PERFORM] Configuration tips for very large database

2015-02-12 Thread Nico Sabbi
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

[PERFORM] Configuration tips for very large database

2015-02-12 Thread Nico Sabbi
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

Re: [PERFORM] Configuration tips for very large database

2015-02-14 Thread Nico Sabbi
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