Re: [GENERAL] performance issues with DBI module when data too big

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: [GENERAL] performance issues with DBI module when data too big
Дата
Msg-id 200206031750.g53HoH203184@saturn.janwieck.net
обсуждение исходный текст
Ответ на performance issues with DBI module when data too big  ("Nicolas Nolst" <nnolst@hotmail.com>)
Список pgsql-admin
Nicolas Nolst wrote:
[text/html is unsupported, treating like TEXT/PLAIN]

> [...]
> <P>My problem is that populating my database is slower  when the data gets bigger and the performance falls
dramatically.I thought that is would be improve with my indexes but the problem still persists.</P> 
> <P>Could you please give me some clues that could solve this issue.</P>

    Is your database frequently vacuumed and analyzed (and do you
    frequently read frequently asked questions)?

> <P>Thanks.</P>
> <P><BR> <BR><BR>Nicolas Nolst </P>

    And just for the record, do you prefer answers to  HTML  mail
    in Postscript, PDF, DVI or nothing at all?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



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

Предыдущее
От: juerg.rietmann@pup.ch
Дата:
Сообщение: how to dump functuions and views
Следующее
От: "Sander Steffann"
Дата:
Сообщение: Re: multiple instances on one box?