On Jun 28, 2007, at 15:26 , Burak Seydioglu wrote:
> I am having performance issues with a table that holds session_data.
> This table is heavily updated and daily vacuumed.
If it's heavily updated, vacuuming once a day may not be enough. You
can elect to vacuum a single table.
What's the output of VACUUM VERBOSE session ?It should tell you how
many dead tuples were removed.
You may also want to consider using autovacuum to help keep your
session table fairly clean.
grzm seespotcode net
In response to
pgsql-novice by date
|Next:||From: Burak Seydioglu||Date: 2007-06-28 23:05:18|
|Subject: Re: Query performance on session table|
|Previous:||From: Burak Seydioglu||Date: 2007-06-28 20:26:41|
|Subject: Query performance on session table|