[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Configuration tips for very large database
From:       Nico Sabbi <nicola.sabbi () poste ! it>
Date:       2015-02-14 19:42:26
Message-ID: 54DFA522.4020407 () poste ! it
[Download RAW message or body]

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
> process the whole thing every time if you expect it to be scalable.
>
> What kind of queries are you running that have slowed down?
>
> Post an explain analyze so people can diagnose. Possibly it's a
> query/indexing issue rather than a hardware one.
>

Thanks everybody for the answers. At the moment I don't have the queries 
at hand (saturday:-) ).
I'll post them next week.

I'd really like to avoid data partitioning if possible. It's a thing 
that gives me a strong stomach ache.



-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]