From: CHEWTC@ap.nec.com.sg
To: pgsql-performance@postgresql.org
Subject: Postgresql performance
Date: Wed, 22 Oct 2003 18:25:51 +0800
Message-ID: <OFF1ADE4F4.BF0D248E-ON48256DC7.00374EB1@nec.com.sg> (raw)
Hi
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.
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.
Do we need to apply any patches or maintenace?
Please be informed that NEC Singapore Pte Ltd is now known as NEC Solutions
Asia Pacific Pte Ltd.
Our address and contact numbers remain.
Email: chewtc@ap.nec.com.sg
http://www.nec.com.sg/ap
Thank you,
REgards.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: CHEWTC@ap.nec.com.sg
Subject: Re: Postgresql performance
In-Reply-To: <OFF1ADE4F4.BF0D248E-ON48256DC7.00374EB1@nec.com.sg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox