Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f2UEckK53773 for ; Fri, 30 Mar 2001 09:38:46 -0500 (EST) (envelope-from pgsql-admin-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2T8eKU31267 for ; Thu, 29 Mar 2001 03:40:20 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f2T8De613052 for pgsql-admin@postgresql.org; Thu, 29 Mar 2001 03:13:40 -0500 (EST) (envelope-from news) From: Marcin Kowalski X-Newsgroups: comp.databases.postgresql.admin Subject: Re: pg_dump potential bug Date: Thu, 29 Mar 2001 10:13:58 +0200 Organization: Datrix Solutions Lines: 35 Message-ID: <99uqrf$cmv$1@news.tht.net> References: <18053.985792976@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: scrappy@hub.org User-Agent: KNode/0.4 To: pgsql-admin@postgresql.org X-Archive-Number: 200103/260 X-Sequence-Number: 1116 Hi Thanks for the help, in fact that is Exactly what is wrong. The pg_shadow table has duplicated entries in it, I think I'm going to create a unique index on it. BTW I've migrated the entrie database to PG7.1RC1, running quite a big search on the database basically involving a huge amount of selects. Currently I'm curising at 1250 selects per second (simple select, no Joins) from multiple tables with mutliple data, pretty fast I think. (But I still have +- 10 Million to do :-) ). ANyone have any ideas on how to improve performace, currently have indices on key fields and am clustering (vacuum + vacuum analyze done)?? Are there any command line parameters I can try to increase performance..?? Thanks in ADvance MarCIn Tom Lane wrote: > Marcin Kowalski writes: >> Is it possible that one of the system tables has been corrupted and shows >> multiple entries for the tables? > > Come to think of it, this is a fairly likely behavior if you have > multiple entries in pg_shadow with the same usesysid. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl >