Re: Postgresql performance - Mailing list pgsql-performance

From CHEWTC@ap.nec.com.sg
Subject Re: Postgresql performance
Date
Msg-id OF4A60A957.DA6FB09E-ON48256DC8.0009C7DB@nec.com.sg
Whole thread Raw
In response to Postgresql performance  (CHEWTC@ap.nec.com.sg)
List pgsql-performance

Hi

The Postgresql package came from the Redhat v9.0 CDROM.
I have checked the version using psql --version and it showed v7.3.2

The duplication of table names is in the same schema.

How to check the pg_dump version?


Thank you,
REgards.





               
                      Tom Lane
               
                      <tgl@sss.pgh.pa.u        To:       CHEWTC@ap.nec.com.sg
               
                      s>                       cc:       pgsql-performance@postgresql.org
               
                                               Subject:  Re: [PERFORM] Postgresql performance
               
                      22/10/2003 10:03
               
                      PM
               

               

               




CHEWTC@ap.nec.com.sg writes:
> Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We
have
> Windows2000 client machines inserting records into the Postgresql tables
> via ODBC.

> After a few weeks of usage, when we do a \d at the sql prompt, there was
a
> duplicate object name, ie it can be a duplicate row of index or table.
> When we do a \d table_name, it will show a duplication of column names
> inside the table.

Are you sure you are using 7.3 psql?  This sounds like something that
could happen with a pre-7.3 (not schema aware) psql, if there are
multiple occurrences of the same table name in different schemas.

> It doesnt affect the insertion/updating of the tables, but when we do a
> pg_dump  -Da -t <table_name> <db_name> > /exp/<table_name>.sql, it will
not
> do a proper backup/dump.

I'd wonder about whether you have the right pg_dump, too.

                                     regards, tom lane






pgsql-performance by date:

Previous
From: CHEWTC@ap.nec.com.sg
Date:
Subject: Re: Postgresql performance
Next
From: Mario Weilguni
Date:
Subject: Re: vacuum locking