exist? Are the updates to indexed columns?
Sorry I was wrong when I said the updates are to the indexed columns. The
updates are to the 'data[]' column which doesn't have any index.
On Wed, Apr 30, 2014 at 10:45 AM, Elanchezhiyan Elango wrote:
> Missed to answer this one:
>
Missed to answer this one:
>
> Is the 5GB for the table plus indexes, or just the table itself?
No it's not including the the indices. Including indices it's actually
17GB!!
On Wed, Apr 30, 2014 at 10:40 AM, Elanchezhiyan Elango wrote:
> Sergey,
> Thanks for the aggre
fault of
1 min because updates anyways happen only every 5 minutes at the max. So I
don't see a point in running autovacuum more frequently than 1min. Correct
me if my settings look wrong.
Thanks,
Elan.
On Wed, Apr 30, 2014 at 8:36 AM, Jeff Janes wrote:
> On Tue, Apr 29, 2014 at 4:59
Hi,
I need help on deciding my vacuuming strategy. I need to know if I ever
need to do 'vacuum full' for my tables.
Tables1: Following is the query patterns on 4 high traffic table in my
database:
1. Every 5 minutes about 5 rows in the table are updated. And for a
given clock hour the same 50
