On Thu, Sep 1, 2011 at 10:04 AM, Rik Bellens wrote:
>
> after running reindex on the stats_count_pkey, the disk size of this index
> was reduced with about 2 gigs, but the size of the table itself was still
> very large.
> running 'vacuum full' also reduced the table size from 14 gigs to about 2
>
Op 01-09-11 14:43, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 6:38 AM, Rik Bellens wrote:
Op 01-09-11 14:22, Scott Marlowe schreef:
Yeah, could be. Take a look at this page:
http://wiki.postgresql.org/wiki/Show_database_bloat and see if the
query there sheds some light on your situ.
thank
Rik Bellens wrote:
> I have two large tables in a database, one containing original data
and
> the other one derived from the first table. The first table contains
> several columns and indexes, while the second table has less columns
and
> only one index. Both tables have the same number of rows.
On Thu, Sep 1, 2011 at 6:38 AM, Rik Bellens wrote:
> Op 01-09-11 14:22, Scott Marlowe schreef:
>> Yeah, could be. Take a look at this page:
>> http://wiki.postgresql.org/wiki/Show_database_bloat and see if the
>> query there sheds some light on your situ.
>
> thanks for this answer
>
> if i run
On Thu, Sep 1, 2011 at 6:38 AM, Rik Bellens wrote:
> Op 01-09-11 14:22, Scott Marlowe schreef:
>>
>> On Thu, Sep 1, 2011 at 6:05 AM, Rik Bellens
>> wrote:
>>>
>>> Op 01-09-11 13:31, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellens
wrote:
>
> Hello,
>
Op 01-09-11 14:22, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 6:05 AM, Rik Bellens wrote:
Op 01-09-11 13:31, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellens
wrote:
Hello,
I have two large tables in a database, one containing original data and
the
other one derived fro
Op 01-09-11 13:31, Scott Marlowe schreef:
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellens wrote:
Hello,
I have two large tables in a database, one containing original data and the
other one derived from the first table. The first table contains several
columns and indexes, while the second table h
On Thu, Sep 1, 2011 at 4:32 AM, Rik Bellens wrote:
>
> Hello,
>
> I have two large tables in a database, one containing original data and the
> other one derived from the first table. The first table contains several
> columns and indexes, while the second table has less columns and only one
> ind
