Re: Cannot Delete
От
Ang Chin Han
Тема
Re: Cannot Delete
Дата
Msg-id
3F8A4BCE.7030504@bytecraft.com.my
Ответ на
Re: Cannot Delete (Alex)
Список
Дерево обсуждения
Cannot Delete Alex <alex@meerkatsoft.com>
Re: Cannot Delete Tom Lane <tgl@sss.pgh.pa.us>
Re: Cannot Delete Alex <alex@meerkatsoft.com>
Re: Cannot Delete Dennis Gearon <gearond@fireserve.net>
Re: Cannot Delete Ang Chin Han <angch@bytecraft.com.my>
Re: Cannot Delete Tim McAuley <mcauleyt@tcd.ie>
Alex wrote: > I tried vacuum, the db and tables and did not gain any performance. Did you try VACUUM only or VACUUM ANALYZE (or even just ANALYZE)? > I experience this problem on different machines and yet, when i reload > the date it did speed up things considerably. It does sound like you haven't ANALYZE'd your data. Try that. -- Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 2:30pm up 291 days, 6:04, 9 users, load average: 6.08, 6.02, 6.01
В списке pgsql-general по дате отправления
