BUG #7603: Application takes long time to fetch data from postgresql database

Поиск
Список
Период
Сортировка
От devenmthaker@gmail.com
Тема BUG #7603: Application takes long time to fetch data from postgresql database
Дата
Msg-id E1TNm3t-0000Wp-ME@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7603: Application takes long time to fetch data from postgresql database  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      7603
Logged by:          Deven
Email address:      devenmthaker@gmail.com
PostgreSQL version: 9.0.3
Operating system:   Windows 2003 R2 64 BITS
Description:        =


Hi,
My application takes longer time (we see time out even) when data to be
fetched from Postgresql 9.0.3 is around 1900000 records. I am doing an
improvement at application level, but from database side any performance
tuning do i need to do?
I have not changed any parameters in postgresql.conf, using default values.

My PC has RAM of 4 GB.

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

Предыдущее
От: daniel.heden@sweco.se
Дата:
Сообщение: BUG #7602: Select with many joins against the same table is very slow compared to 9.2.0.
Следующее
От: Deven Thaker
Дата:
Сообщение: Fetching large no of data takes lot of time