This is a multi-part message in MIME format.
------_=_NextPart_001_01CA2D31.26C97C0C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi all,
Any help on the following would be greatly appreciated, every evening
most of the data on our postgres 8.1 install is deleted and then a new
set of data is imported into the database (around 100 million row).
After this takes place we run a Vacuum Analyse on the whole database.
Last night I got the error
Error Relation 41036649 deleted while still in use
There are other queries running on the database at the time of the
Vaccum but I was under the impression a Vacuum Analyse only removes
deleted / unused tuples etc. Is this not correct ?
Is there anyway I can see what relation 41036649 was before it was
deleted
Thanks for all the help
Francis
___________________________________________________
This email is intended for the named recipient. The information contained=
in it is confidential. You should not copy it for any purposes, nor
disclose its contents to any other party. If you received this email
in error, please notify the sender immediately via email, and delete it from
your computer.
Any views or opinions presented are solely those of the author and do not=
necessarily represent those of the company.
Cromwell Tools Limited, PO Box 14, 65 Chartwell Drive
Wigston, Leicester LE18 1AT. Tel 0116 2888000
Registered in England and Wales, Reg No 00986161
VAT GB 115 5713 87 900
__________________________________________________
------_=_NextPart_001_01CA2D31.26C97C0C
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.5.7638.1">
<TITLE>Vacuum Error - Relation Deleted while still in use</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Any help on the following would be greatly=
appreciated, every evening most of the data on our postgres 8.1 inst=
all is deleted and then a new set of data is imported into the database (ar=
ound 100 million row). After this takes place we run a Vacuum Analyse=
on the whole database.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Last night I got the error</FONT>
</P>
<P><B><I><FONT SIZE=3D2 FACE=3D"Arial">Error Relation 41036649 deleted whil=
e still in use</FONT></I></B><I></I>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">There are other queries running on the dat=
abase at the time of the Vaccum but I was under the impression a Vacuum Ana=
lyse only removes deleted / unused tuples etc. Is this not correct ?<=
/FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Is there anyway I can see what relation 41=
036649 was before it was deleted </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks for all the help</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Francis</FONT>
</P>
</BODY>
___________________________________________________
This email is intended for the named recipient. The information conta=
ined
in it is confidential. You should not copy it for any purposes, nor=
disclose its contents to any other party. If you received this email=
in error, please notify the sender immediately via email, and delete
it from your computer.
Any views or opinions presented are solely those of the author and do=
not
necessarily represent those of the company.
Cromwell Tools Limited, PO Box 14, 65 Chartwell Drive
Wigston, Leicester LE18 1AT. Tel 0116 2888000
Registered in England and Wales, Reg No 00986161
VAT GB 115 5713 87 900
__________________________________________________
</HTML>
------_=_NextPart_001_01CA2D31.26C97C0C--
