X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 44267DABF4
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 24 Oct 2005 16:11:54 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 12609-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Mon, 24 Oct 2005 19:11:51 +0000 (GMT)
Received: from qproxy.gmail.com (qproxy.gmail.com [72.14.204.200])
	by svr1.postgresql.org (Postfix) with ESMTP id 30C26DAD38
	for <pgsql-performance@postgresql.org>;
	Mon, 24 Oct 2005 16:11:51 -0300 (ADT)
Received: by qproxy.gmail.com with SMTP id e12so295284qbe
	for <pgsql-performance@postgresql.org>;
	Mon, 24 Oct 2005 12:11:53 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=Xs5nE40jFS5PimiRBxr52d2CVPR9Fc9iQnItx4w+teSxXIUtyTONLl3mTjW9kLoELm+82irqHBUxglFiueRBA3om/p0AjhCowYJhQNYpQ8JVrQCNygxEiMtt464ipLVDDpVuGq4ehLU9MVe7PJbk0MOuS5f5R+Z4BVrjFiURkzk=
Received: by 10.65.105.20 with SMTP id h20mr662394qbm;
	Mon, 24 Oct 2005 12:11:53 -0700 (PDT)
Received: by 10.65.240.20 with HTTP; Mon, 24 Oct 2005 12:11:53 -0700 (PDT)
Message-ID: <3cf983d0510241211w4f577241v33aab8feda4f604f@mail.gmail.com>
Date: Mon, 24 Oct 2005 19:11:53 +0000
From: Rodrigo Madera <rodrigo.madera@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Inefficient escape codes.
In-Reply-To: <3cf983d0510241208se3076fo2f1fa0b8d88f2714@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_18628_15991171.1130181113540"
References: <16F953410A0F1346848DCB476A989CFE34B8@swtexchange2.technology.de>
	<3cf983d0510241208se3076fo2f1fa0b8d88f2714@mail.gmail.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.529 required=5 tests=[HTML_20_30=0.504,
	HTML_MESSAGE=0.001, RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200510/336
X-Sequence-Number: 15104

------=_Part_18628_15991171.1130181113540
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Now this interests me a lot.

Please clarify this:

I have 5000 tables, one for each city:

City1_Photos, City2_Photos, ... City5000_Photos.

Each of these tables are: CREATE TABLE CityN_Photos (location text, lo_id
largeobectypeiforgot)

So, what's the limit for these large objects? I heard I could only have 4
billion records for the whole database (not for each table). Is this true?
If this isn't true, then would postgres manage to create all the large
objects I ask him to?

Also, this would be a performance penalty, wouldn't it?

Much thanks for the knowledge shared,
Rodrigo

------=_Part_18628_15991171.1130181113540
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Now this interests me a lot.<br>
<br>
Please clarify this:<br>
<br>
I have 5000 tables, one for each city:<br>
<br>
City1_Photos, City2_Photos, ... City5000_Photos.<br>
<br>
Each of these tables are: CREATE TABLE CityN_Photos (location text, lo_id l=
argeobectypeiforgot)<br>
<br>
So, what's the limit for these large objects? I heard I could only have
4 billion records for the whole database (not for each table). Is this
true? If this isn't true, then would postgres manage to create all the
large objects I ask him to?<br>
<br>
Also, this would be a performance penalty, wouldn't it?<br>
<br>
Much thanks for the knowledge shared,<br><span class=3D"sg">
Rodrigo</span><div><span class=3D"e" id=3D"q_10724086ca7e0d29_2"><br>
<br><br>

</span></div>

------=_Part_18628_15991171.1130181113540--