Re: [PERFORM] Large rows number, and large objects

2011-07-20 Thread Andrzej Nakonieczny
W dniu 20.07.2011 17:57, Jose Ildefonso Camargo Tolosa pisze: [...] Many of the advantages of partitioning have to do with maintenance tasks. For example, if you gather data on a daily basis, it's faster to drop the partition that contains Thursday's data than it is to do a DEL

Re: [PERFORM] Large rows number, and large objects

2011-07-20 Thread Robert Haas
On Wed, Jul 20, 2011 at 11:57 AM, Jose Ildefonso Camargo Tolosa wrote: > On Tue, Jul 19, 2011 at 3:57 PM, Robert Haas wrote: >> On Sun, Jun 19, 2011 at 10:19 PM, Jose Ildefonso Camargo Tolosa >> wrote: >> > So, the question is, if I were to store 8TB worth of data into large >> > objects system,

Re: [PERFORM] Large rows number, and large objects

2011-07-20 Thread Jose Ildefonso Camargo Tolosa
On Tue, Jul 19, 2011 at 3:57 PM, Robert Haas wrote: > On Sun, Jun 19, 2011 at 10:19 PM, Jose Ildefonso Camargo Tolosa > wrote: > > So, the question is, if I were to store 8TB worth of data into large > > objects system, it would actually make the pg_largeobject table slow, > > unless it was auto