Dealing with large query results

Поиск
Список
Период
Сортировка
От Matthew Hagerty
Тема Dealing with large query results
Дата
Msg-id 4.1.19990208145905.00a0b8d0@mail.venux.net
обсуждение исходный текст
Ответы Re: [INTERFACES] Dealing with large query results  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-interfaces
Greetings,

I keep seeing reference to an 8K limit on query results.  So how to deal
with query results greater than 8K?  Am I under the wrong impression that
when you run a query from, say libpq, that each retch row is returned only
when you execute a fetchrow?  Or is the whole query stuffed in to a buffer
which has an 8K limit?

I have to deal with some queries that create a huge result, and/or doing
reports requires a large result set.  How can I deal with these larger results?

I'll probably get flamed for asking this one but, how can I step through a
table?  Hey, sometimes you just have to do it.

Thanks,
Matthew


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

Предыдущее
От: Peter T Mount
Дата:
Сообщение: Re: [INTERFACES] Re: connecting: unix socket? Yes. TCPIP port? No.-i? Yes.
Следующее
От: Matthew Hagerty
Дата:
Сообщение: Rapid web based apps?