Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 234659FB29D for ; Mon, 2 Apr 2007 07:34:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 17748-07 for ; Mon, 2 Apr 2007 07:34:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from hyperion.scode.org (hyperion.scode.org [85.17.42.115]) by postgresql.org (Postfix) with ESMTP id 7490D9FA5F7 for ; Mon, 2 Apr 2007 07:34:46 -0300 (ADT) Received: by hyperion.scode.org (Postfix, from userid 1001) id 31E52239479; Mon, 2 Apr 2007 12:34:44 +0200 (CEST) Date: Mon, 2 Apr 2007 12:34:44 +0200 From: Peter Schuller To: Marc Mamin Cc: pgsql-performance@postgresql.org Subject: Re: Scaling SELECT:s with the number of disks on a stripe Message-ID: <20070402103443.GA57038@hyperion.scode.org> References: <20070330051645.GA78431@hyperion.scode.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="GvXjxJ+pjyke8COw" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/7 X-Sequence-Number: 23884 --GvXjxJ+pjyke8COw Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello, > If you are dealing with timed data or similar, you may consider to > partition your table(s). Unfortunately this is not the case; the insertion is more or less random (not quite, but for the purpose of this problem it is). Thanks for the pointers though. That is sure to be useful in some other context down the road. --=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --GvXjxJ+pjyke8COw Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (FreeBSD) iD8DBQFGENxCDNor2+l1i30RArEZAKCnhWTIVqXnj3Z5heNxDu06Jh8wwgCgp3Kc fAUkW8RaBryHHiiF/T+o2qg= =Gt4g -----END PGP SIGNATURE----- --GvXjxJ+pjyke8COw--