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

Vacuum

From: Tim Stoddard <tims(at)dcs(dot)state(dot)ar(dot)us>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-sql(at)postgreSQL(dot)org
Subject: Vacuum
Date: 1999-03-18 14:41:21
Message-ID: 36F11091.6E5C6C43@dcs.state.ar.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
When I delete 2k-3k of records from a table the vacuum process seems
to take forever.  I have let the vacuum run for 24 hours before with
not luck.

Can someone one explain to me what is going on?

--
Tim Stoddard
======================================================================

  Open Systems UNIX

  In a world without fences, who needs Gates? -- Unknown
======================================================================




Responses

pgsql-sql by date

Next:From: Sascha SchumannDate: 1999-03-18 19:58:31
Subject: Re: [SQL] Vacuum
Previous:From: Frederic NourryDate: 1999-03-18 09:30:06
Subject: pgsql-sql@postgresql.org

pgsql-general by date

Next:From: hoelcDate: 1999-03-18 16:41:00
Subject: delete data
Previous:From: Adriaan JoubertDate: 1999-03-18 07:48:37
Subject: PL and composite return types

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