Re: table size growing out of control

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: table size growing out of control
Дата
Msg-id Pine.LNX.4.44.0207151447530.29212-100000@css120.ihs.com
обсуждение исходный текст
Ответ на table size growing out of control  (Robert Treat <rtreat@webmd.net>)
Список pgsql-general
On 15 Jul 2002, Robert Treat wrote:

> I have a table of about 5000 records that I noticed was taking a very
> long time to do simple selects from. I looked at explain analyze and got

Did you check the actual physical file sizes of your indexes and tables
on the disk?  One might have been growing but not shoing it in the tables
you looked at.

Did you have stalled transactions holding a lock on anything?

That's all I can think of.




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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Question: merit / feasibility of compressing frontend
Следующее
От: Alex Rice
Дата:
Сообщение: Re: MySQL vs. PostgreSQL