\d very, very, very slow

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема \d very, very, very slow
Дата
Msg-id 20020803230540.A28986@blighty.com
обсуждение исходный текст
Ответы Re: \d very, very, very slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm seeing very, very slow response to \d <tablename> - around 15-20
seconds on an otherwise idle Netra.

PostgreSQL 7.2.1 on sparc-sun-solaris2.8, compiled by cc -xarch=v9 -Xa

Running psql -E shows that \d is issuing 4 queries. Picking one at
random at running it through explain analyze shows three nested
seqscans and a few joins, taking 6500ms.

(Running the same query on a Linux box running Postgresql 7.2 with the
 same schema and similar postgresql.conf  shows the same query plan,
 taking 80ms.)

So is 15-20 seconds for \d unusual? If so, where should I start looking
to see what's broken?

Any thoughts appreciated.

Cheers,
  Steve



В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: CVS problem
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: CVS problem