Re: Postgresql performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql performance
Дата
Msg-id 11085.1066831385@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgresql performance  (CHEWTC@ap.nec.com.sg)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: CHEWTC@ap.nec.com.sg
Дата:
Сообщение: Postgresql performance
Следующее
От: "Medora Schauer"
Дата:
Сообщение: slow select