> -Original Message-
> Maybe...
>
> Yeah, i think, 16 MByte isn't the real limit, yes. And i've seen queries
larger
> than that limit, but i can't find the link, sorry.
> (maybe depesz.com, dunno, can't remember, i'm sorry)
>
What kind of use-case would generate that large of a query?
On Tue, Jun 7, 2011 at 2:38 PM, Andreas Kretschmer
wrote:
> Yeah, i think, 16 MByte isn't the real limit, yes. And i've seen
> queries larger than that limit, but i can't find the link, sorry.
> (maybe depesz.com, dunno, can't remember, i'm sorry)
The thread linked seems to mainly be talking abou
On Jun 7, 2011, at 5:18 PM, Pavel Stehule wrote:
> Hello
>
> no, it means some different.
>
> we tested a SQL about 20MB with success.
>
> The maximum of varlena is 1GB - so it is necessary to be possible send
> a query longer 1GB. But you need a free RAM 3-5x larger then query
> size.
>
Tha
Pavel Stehule wrote:
> 2011/6/7 :
> >
> > Zitat von AI Rumman :
> >
> >> Is there any maximum size limit for a query string in Postgresql 9.0.1?
> >> If yes, what is it ?.
> >>
> >
> > Not sure, but maybe 16 MByte, see
> > http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
>
> is
2011/6/7 :
>
> Zitat von AI Rumman :
>
>> Is there any maximum size limit for a query string in Postgresql 9.0.1?
>> If yes, what is it ?.
>>
>
> Not sure, but maybe 16 MByte, see
> http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
isn't it limit for PHP?
Pavel
>
>
> --
> Sent vi
Zitat von AI Rumman :
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what is it ?.
Not sure, but maybe 16 MByte, see
http://www.phpbuilder.com/board/archive/index.php/t-10250064.html
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
Hello
no, it means some different.
we tested a SQL about 20MB with success.
The maximum of varlena is 1GB - so it is necessary to be possible send
a query longer 1GB. But you need a free RAM 3-5x larger then query
size.
Regards
Pavel Stehule
2011/6/7 Vibhor Kumar :
>
> On Jun 7, 2011, at 4:0
On Jun 7, 2011, at 4:09 PM, AI Rumman wrote:
> Is there any maximum size limit for a query string in Postgresql 9.0.1?
> If yes, what is it ?.
track_activity_query_size parameter.
http://www.postgresql.org/docs/9.0/static/runtime-config-statistics.html
Thanks & Regards,
Vibhor Kumar
Enterprise
Is there any maximum size limit for a query string in Postgresql 9.0.1?
If yes, what is it ?.
2010/12/19 Jasen Betts
> I have some values of perhaps 20Mb that I might want to store samples
> of in a partitioned table. (so I can delete them easily) what's the right
> way?
>
>
20 Mbits or 20 MBytes?
how big samples?
answer to your question depends on what you want to do with these samples
On 2010-12-08, Tom Lane wrote:
> Adrian Klaver writes:
>> On 12/08/2010 08:04 AM, Tom Lane wrote:
>>> The rationale for having a limit of this sort is (a) we *don't* want
>>> the upper limit of declarable length to be encoding-dependent; and
>>> (b) if you are trying to declare an upper limit tha
On 12/08/2010 09:05 AM, Tom Lane wrote:
Adrian Klaver writes:
On 12/08/2010 08:04 AM, Tom Lane wrote:
The rationale for having a limit of this sort is (a) we *don't* want
the upper limit of declarable length to be encoding-dependent; and
(b) if you are trying to declare an upper limit that's g
Adrian Klaver writes:
> On 12/08/2010 08:04 AM, Tom Lane wrote:
>> The rationale for having a limit of this sort is (a) we *don't* want
>> the upper limit of declarable length to be encoding-dependent; and
>> (b) if you are trying to declare an upper limit that's got more than a
>> few digits in i
On 12/08/2010 08:04 AM, Tom Lane wrote:
Adrian Klaver writes:
So the answer is, it depends on your encoding.
No, it doesn't. What Rob is looking for is this bit in htup.h:
/*
* MaxAttrSize is a somewhat arbitrary upper limit on the declared size of
* data fields of char(n) and similar t
Thanks Tom, this is very helpful.
Rob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Adrian Klaver writes:
> So the answer is, it depends on your encoding.
No, it doesn't. What Rob is looking for is this bit in htup.h:
/*
* MaxAttrSize is a somewhat arbitrary upper limit on the declared size of
* data fields of char(n) and similar types. It need not have anything
* directly
On Wednesday 08 December 2010 7:06:07 am Rob Gansevles wrote:
> Adrian,
>
> Thanks for the reply, but this refers to max row or field size, it
> does not tell me where the max varchar limit of 10485760 comes from
> and if this is fixed or whether it depends on something else
>
> Has anyone some inf
Adrian,
Thanks for the reply, but this refers to max row or field size, it
does not tell me where the max varchar limit of 10485760 comes from
and if this is fixed or whether it depends on something else
Has anyone some info on this?
Rob
On Wed, Dec 8, 2010 at 3:34 PM, Adrian Klaver wrote:
> O
On Wednesday 08 December 2010 5:47:25 am Rob Gansevles wrote:
> Hello,
>
> Does anyone know what the maximum length is for char or varchar
> columns with limit.
> I saw some answers to this same question referring to section 8.3 of
> the docs, but I don't see the actual numbers there.
>
> I know yo
Hello,
Does anyone know what the maximum length is for char or varchar
columns with limit.
I saw some answers to this same question referring to section 8.3 of
the docs, but I don't see the actual numbers there.
I know you can go to 1GB if you don't specify the limit, but I would
like to know wha
Hello
theoretically there are only limits on data types 1GB. But really big
fields has negative impact on speed (it depends on RAM). If you have
fields bigger than 10-20M, than is better to use BLOBs.
Regards
Pavel Stehule
On 21/11/2007, Ottavio Campana <[EMAIL PROTECTED]> wrote:
> I want to pas
I want to pass some text to a function which is going to store it for
some tsearch queries.
Is there a limit on the length of the text I can pass to a function?
--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
signature.asc
Description: OpenPGP digital signature
On Wed, 2006-10-18 at 00:41 -0700, roopa perumalraja wrote:
> Hi
>
> Thanks for your reply.
>
> explain select * from tk_20060403;
> QUERY
> PLAN
> --
> Seq S
warrant a flame, but I think in general the *Nix OS
versions may have better disk I/O.
Greg W.
-Original Message-
From: [EMAIL PROTECTED] on behalf of roopa perumalraja
Sent: Wed 10/18/2006 12:41 AM
To: pgsql-general@postgresql.org
Cc: Michael Fuhr; louis gonzales
Subje
perumalrajaSent: Wednesday, October 18,
2006 8:10 AMTo: pgsql-general@postgresql.orgCc: Michael
FuhrSubject: Re: [GENERAL] Maximum size of
database
Thanks for your reply.
I have answered your questions below.
1 & 2) System: Microsoft Windows XP
Professional Version
explain analyze verbose select * from tk_ ;
roopa perumalraja wrote:
Hi
Thanks for your reply.
explain select * from tk_20060403;
QUERY PLAN
--
Seq S
Hi Thanks for your reply. explain select * from tk_20060403; QUERY PLAN -- Seq Scan on tk_20060403 (cost=0.00..95561.30 rows=3609530 width=407)(1 row) will
also, run
EXPLAIN
on any command, show the results of this. In particular, if you have
some commands that are taking 'even longer?'
roopa perumalraja wrote:
Thanks for your reply.
I have answered your questions below.
1 & 2) System: Microsoft Windows XP Professional
Version
Thanks for your reply. I have answered your questions below. 1 & 2) System: Microsoft Windows XP Professional Version 2002 Computer: Intel Pentium CPU 3.40GHz, 960MB of RAM 3) shared_buffers = 2 autovaccum = on 4) Yes, I am vacuuming & analyzing the datab
roopa perumalraja wrote
I would like to know that what can be the maximum size of database in
postgres 8.1.4. Currently my database size is 37GB & its pretty slow.
I wonder if its b'cos of huge amount of data in it.
http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
Slowness reason ca
On Tue, Oct 17, 2006 at 07:26:25PM -0700, roopa perumalraja wrote:
> I would like to know that what can be the maximum size of database in
> postgres 8.1.4.
http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
> Currently my database size is 37GB & its pretty slow. I wonder if
> its b'cos of hug
Hi I would like to know that what can be the maximum size of database in postgres 8.1.4. Currently my database size is 37GB & its pretty slow. I wonder if its b'cos of huge amount of data in it. Thanks in advance. Roopa
How low will we go? Check out Yahoo! Messengers low PC-to-Phone c
Nageshwar Rao wrote:
What is the maximum number we can give for varchar (number) in postgresql
7.4.x
Details on data-types are in the manuals under "Data Types". Go to
http://www.postgresql.org, click "Documentation" then choose "7.4
(without comments)" on the right-hand side. Data Types are in t
Title: Maximum size for varchar
What is the maximum number we can give for varchar (number) in postgresql 7.4.x
Thanks
Rao
On Wed, 2005-02-23 at 08:34, Molinet Sylviane wrote:
> Hello,
>
> could you be so kind to help me with following requests ?
>
> I need the maximum size of the following types :
> varchar(n)
~ 1 Meg
> numeric(n,p)
no limit (actually ~ 1 Gig)
> text
~ 1 Gig
> bytea
~ 1 Gig
> Could you pleas
On Wed, 2005-02-23 at 15:34 +0100, Molinet Sylviane wrote:
> Hello,
>
> could you be so kind to help me with following requests ?
>
> I need the maximum size of the following types :
> varchar(n)
> numeric(n,p)
> text
> bytea
>
> Could you please give me the name of articles or publications and
Molinet Sylviane wrote:
Hello,
could you be so kind to help me with following requests ?
I need the maximum size of the following types :
varchar(n)
numeric(n,p)
text
bytea
Could you please give me the name of articles or publications and where
I can find it for these requests ?
Well, the manuals
Hello,
could you be so kind to help me with following requests ?
I need the maximum size of the following types :
varchar(n)
numeric(n,p)
text
bytea
Could you please give me the name of articles or publications and where I
can find it for these requests ?
I want to transfer a oracle database 8i t
--- Jonas Lindholm <[EMAIL PROTECTED]> wrote:
> Can a table grow larger than maximum file size ?
> E.g. will PG create an additional file for the table ?
>
> I'm running PG 7.0.3 on Linux where the maximum file size is
> 2GB
The new Linux 2.4 kernel has blown away that file size barrier.
The ne
Can a table grow larger than maximum file size ?
E.g. will PG create an additional file for the table ?
I'm running PG 7.0.3 on Linux where the maximum file size is 2GB
Thanks
/Jonas Lindholm
---(end of broadcast)---
TIP 4: Don't 'kill -9' the p
40 matches
Mail list logo
