Re: \d very, very, very slow
От | Sam Liddicott |
---|---|
Тема | Re: \d very, very, very slow |
Дата | |
Msg-id | D38A0FCD5830E848992DF2D4AF5F6F4FE22508@conwy.leeds.ananova.internal обсуждение исходный текст |
Ответ на | \d very, very, very slow (Steve Atkins <steve@blighty.com>) |
Ответы |
Installing postgresql
|
Список | pgsql-general |
> -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: 04 August 2002 06:52 > To: Steve Atkins > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] \d very, very, very slow > > > Steve Atkins <steve@blighty.com> writes: > > So is 15-20 seconds for \d unusual? > > Very. > > > If so, where should I start looking to see what's broken? > > Well, what query plans are used for the queries issued by \d on each > of your two boxes? Have you done ANALYZE or VACUUM ANALYZE lately? > (Out-of-date stats about the system tables might lead the planner to > make a stupid choice of query plan.) We find that sometimes pgadmin takes this long to show us DB details when we double click on a DB and we vacuum analyse every night. This ispostgres 7.2.1 Sam
В списке pgsql-general по дате отправления: