Drop Tables Very Slow in Postgresql 7.2.1

Поиск
Список
Период
Сортировка
От Maneesha Nunes
Тема Drop Tables Very Slow in Postgresql 7.2.1
Дата
Msg-id 404EBDA5.ED3248AE@phil.com.sg
обсуждение исходный текст
Ответы Re: Drop Tables Very Slow in Postgresql 7.2.1
Список pgsql-performance
Hello there !!!

I  am using  postgresql7.2.1  as the backend for an E.R.P system running
on Linux  Redhat 7.2(Enigma)
The database size is around 20-25GB
Dropping of an individual table whose size is around 200Mb takes more
than 7 mins, and also increases the load on our System
The database is vacuumed/ reindexed on a daily basis.

We have recreated the same database on a Linux Redhat release 9 OS, and
used PostgreSQL 7.3.2, the drop  here is really  fast.

Any  suggestions as to  how I  could improve the performance of drop on
postgresql7.2.1.


Thanks
maneesha.



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

Предыдущее
От: Marty Scholes
Дата:
Сообщение: Re: Scaling further up
Следующее
От: Mike Bridge
Дата:
Сообщение: High CPU with 7.4.1 after running for about 2 weeks