pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedWhat's that query limit again?
4+ messages / 4 participants
[nested] [flat]
* What's that query limit again?
@ 1999-02-25 07:58 Matthew Hagerty <matthew@venux.net>
1999-02-25 09:30 ` Re: [INTERFACES] What's that query limit again? Peter T Mount <peter@retep.org.uk>
1999-02-25 10:05 ` Re: [INTERFACES] What's that query limit again? Mark Himsley <markh@clockworkweb.com>
1999-02-25 15:01 ` Re: [INTERFACES] What's that query limit again? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 3 replies; 4+ messages in thread
From: Matthew Hagerty @ 1999-02-25 07:58 UTC (permalink / raw)
To: pgsql-interfaces
Greetings,
The query limit is 8K right? What about the size of rows returned by a
select? If it is 8K too, then how might I be sure I can get all the
results of a row that has several "text" fields? The user may type more
than 8K total across all the fields...
I'm trying to avoid large objects.
Thanks,
Matthew
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] What's that query limit again?
1999-02-25 07:58 What's that query limit again? Matthew Hagerty <matthew@venux.net>
@ 1999-02-25 09:30 ` Peter T Mount <peter@retep.org.uk>
2 siblings, 0 replies; 4+ messages in thread
From: Peter T Mount @ 1999-02-25 09:30 UTC (permalink / raw)
To: Matthew Hagerty <matthew@venux.net>; +Cc: pgsql-interfaces
On Thu, 25 Feb 1999, Matthew Hagerty wrote:
> Greetings,
>
> The query limit is 8K right? What about the size of rows returned by a
> select? If it is 8K too, then how might I be sure I can get all the
> results of a row that has several "text" fields? The user may type more
> than 8K total across all the fields...
>
> I'm trying to avoid large objects.
There's two 8k limits, one the size of the query, the other the block size
in the table. The latter is changeable (at compile time) upto 32K with
varying levels of success.
The size of a returned result is only limited to the resources of the
server, and in some cases the client.
Peter
--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] What's that query limit again?
1999-02-25 07:58 What's that query limit again? Matthew Hagerty <matthew@venux.net>
@ 1999-02-25 10:05 ` Mark Himsley <markh@clockworkweb.com>
2 siblings, 0 replies; 4+ messages in thread
From: markh@clockworkweb.com @ 1999-02-25 10:05 UTC (permalink / raw)
To: pgsql-interfaces
Matthew Hagerty <matthew@venux.net> wrote:
> The query limit is 8K right?
This 8K limit is going to kill Postgres, IMHO.
I really like Postgres but I am going to have to move to some other
database platform so that I can populate a web site from a database
without having to jump through hoops to split text into 4K blocks.
> I'm trying to avoid large objects.
I don't see the need for them. My opinion is that the backend should
hide large objects from the user. It's all spherical objects to me!
--
Mark Himsley.
Technical Director,
Clockwork Web.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] What's that query limit again?
1999-02-25 07:58 What's that query limit again? Matthew Hagerty <matthew@venux.net>
@ 1999-02-25 15:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 1999-02-25 15:01 UTC (permalink / raw)
To: Matthew Hagerty <matthew@venux.net>; +Cc: pgsql-interfaces
Matthew Hagerty <matthew@venux.net> writes:
> The query limit is 8K right? What about the size of rows returned by a
> select?
There's an 8K limit on the text of a submitted query (I hope to
eliminate that soon, but probably not in time for 6.5). As far as
I can think offhand, there is no a-priori limit on the size of a
query result in either columns or rows.
(Well, I notice a 16-bit column count in T messages, so the FE/BE
protocol will break at 32K or 64K columns in a result, but hopefully
no one will ever run into that...)
Have you tried it? An experiment would've taken less time than
querying the list, I'm sure.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-02-25 15:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-25 07:58 What's that query limit again? Matthew Hagerty <matthew@venux.net>
1999-02-25 09:30 ` Peter T Mount <peter@retep.org.uk>
1999-02-25 10:05 ` Mark Himsley <markh@clockworkweb.com>
1999-02-25 15:01 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox