Skip site navigation (1) Skip section navigation (2)

Re: Query performance on session table

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Burak Seydioglu <buraks78(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Query performance on session table
Date: 2007-06-28 21:38:37
Message-ID: 61BCE13E-A0EE-41BC-8A52-9DA21D23AF78@seespotcode.net (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Michael Glaesemann
grzm seespotcode net



In response to

Responses

pgsql-novice by date

Next:From: Burak SeydiogluDate: 2007-06-28 23:05:18
Subject: Re: Query performance on session table
Previous:From: Burak SeydiogluDate: 2007-06-28 20:26:41
Subject: Query performance on session table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group