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

Re: [GENERAL] problem when vacuuming. . .

From: Karl DeBisschop <kdebisschop(at)spaceheater(dot)infoplease(dot)com>
To: jt-kirkpatrick(at)mpsllc(dot)com
Cc: pgsql-admin(at)hub(dot)org, pgsql-sql(at)hub(dot)org, pgsql-general(at)hub(dot)org, pgsql-interfaces(at)hub(dot)org
Subject: Re: [GENERAL] problem when vacuuming. . .
Date: 1999-04-20 13:17:42
Message-ID: 199904201317.JAA00633@skillet.infoplease.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-sql
For what it's worth, my experience with this error is that your
backend crashed during the update - why it should do that on such a
small set of data, I cannot begin to guess.  But I have always found
the data to be okay, though the query executing at the time will need
to be completed.  Just drop the indexes, complete the query, and
recreate the indexes (I suggets this order for performance reasons,
unless your update depends on using the indexes to perform
efficiently).

You may also want to increase the amount of memory allocated to the
backend, both -B and -S (buffers, and sort buffers)



   From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
   Date: Mon, 19 Apr 1999 18:24:16 -0400
   Organization: MPS, LLC
   Content-Type: text/plain; charset="us-ascii"
   Sender: owner-pgsql-general(at)postgreSQL(dot)org
   Precedence: bulk

   When I vacuum I get two messages:

   NOTICE:  Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (108) IS NOT 
   THE SAME AS HEAP' (82)

   NOTICE:  Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (108) IS NOT THE 
   SAME AS HEAP' (82)


   I had followed some advice I read in one of these postgres mailing lists 
   (from this weekend) regarding case problems when transferring from 
   access97, and I executed both of those updates.  I can't find them now, nor 
   can I remember them, but they replaced certain values in the tables 
   corresponding to the indexes above with the lowercase equivalent of those 
   values.  I'd like to try to reverse the effect - does anyone have a copy of 
   that email from sometime this weekend?

   jt
   

In response to

pgsql-sql by date

Next:From: Maarten BoekholdDate: 1999-04-20 14:10:38
Subject: Re: [SQL] Questions about embedded-sql!
Previous:From: Magnum Ind. da Amazonia S/ADate: 1999-04-20 12:30:00
Subject: Re: [SQL] Questions about embedded-sql!

pgsql-interfaces by date

Next:From: Gene Selkov, Jr.Date: 1999-04-20 13:30:02
Subject: Re: [SQL] Questions about embedded-sql!
Previous:From: Francesco FortugnoDate: 1999-04-20 13:05:01
Subject: unsubscribe pgsql-interfaces@postgreSQL.org

pgsql-general by date

Next:From: Thomas LockhartDate: 1999-04-20 14:40:05
Subject: Re: [INTERFACES] where did that date and time come from??
Previous:From: Herouth MaozDate: 1999-04-20 11:04:04
Subject: RE: [GENERAL] How to get seq after insert

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