pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTable not getting vaccumed.
3+ messages / 3 participants
[nested] [flat]
* Table not getting vaccumed.
@ 2006-09-30 09:25 Nimesh Satam <nimesh.zedo@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Nimesh Satam @ 2006-09-30 09:25 UTC (permalink / raw)
To: pgsql-performance
Hi,
I am trying to vaccum one of the table using the following command:
VACUUM FULL ANALYZE VERBOSE table_name;
But for some reason the table vaccuming is not going ahead. Can you guys let
me know what the problem is.
Regards,
Nimesh.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Table not getting vaccumed.
@ 2006-09-30 16:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Nimesh Satam <nimesh.zedo@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2006-09-30 16:45 UTC (permalink / raw)
To: Nimesh Satam <nimesh.zedo@gmail.com>; +Cc: pgsql-performance
"Nimesh Satam" <nimesh.zedo@gmail.com> writes:
> I am trying to vaccum one of the table using the following command:
> VACUUM FULL ANALYZE VERBOSE table_name;
> But for some reason the table vaccuming is not going ahead.
VACUUM FULL requires exclusive lock on the table, so it's probably
waiting for some open transaction that has a reader's or writer's
lock on it. Look in pg_stat_activity and pg_locks to find out more.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Table not getting vaccumed.
@ 2006-10-02 19:08 Jim C. Nasby <jim@nasby.net>
parent: Nimesh Satam <nimesh.zedo@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jim C. Nasby @ 2006-10-02 19:08 UTC (permalink / raw)
To: Nimesh Satam <nimesh.zedo@gmail.com>; +Cc: pgsql-performance
On Sat, Sep 30, 2006 at 02:55:54PM +0530, Nimesh Satam wrote:
> I am trying to vaccum one of the table using the following command:
>
> VACUUM FULL ANALYZE VERBOSE table_name;
Are you sure you want to do a vacuum full? Normally, that shouldn't be
required.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-10-02 19:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-30 09:25 Table not getting vaccumed. Nimesh Satam <nimesh.zedo@gmail.com>
2006-09-30 16:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-10-02 19:08 ` Jim C. Nasby <jim@nasby.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox