Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CA9B42E3405 for ; Tue, 11 Dec 2007 18:30:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 71429-01-4 for ; Tue, 11 Dec 2007 18:29:58 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.239]) by postgresql.org (Postfix) with ESMTP id 1159E2E36F5 for ; Tue, 11 Dec 2007 18:30:00 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 58so2000948wri for ; Tue, 11 Dec 2007 14:30:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=NzAOyQajSNT9D2LT5ojIY6Y+UGbAwwbssC20NqvU1Gk=; b=C+8Z7/ZVoOfocon9yurUG8t7r/fH2tNOJiy9UQeKCtJFjYGItNfuHO6BWEJheqoh31G0x5MafMqjSDaSlSwlmeSUfsj65+5fycSrEec4OwTiMu3MaY3RKZK+bgTYIXdZTgyqfrM1DteD3YYFoFDUsEKcQTGpr2cso8RbSmriSFM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aWKCbX6qGLQgZqV9Cf0jNtg6XRhHxWZ04glmM4N9wI3mdRWxAg8yVAjtiHFxOxR6+7X1EobghQp5AY+H3DrFHiVqfpPzRdBT/i/qo6Uc2t2L1RnyHAiQ5rze1DSQHGvtvZgjTrQBJP6JyiH4qRyUocjGckpzMlAxBipLzZdorNE= Received: by 10.142.191.2 with SMTP id o2mr4011076wff.1197412199339; Tue, 11 Dec 2007 14:29:59 -0800 (PST) Received: by 10.142.165.8 with HTTP; Tue, 11 Dec 2007 14:29:59 -0800 (PST) Message-ID: Date: Tue, 11 Dec 2007 16:29:59 -0600 From: "Scott Marlowe" To: kelvan Subject: Re: database tuning Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1197016760.4255.474.camel@ebony.site> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/152 X-Sequence-Number: 27968 http://www.postgresql.org/docs/8.1/static/storage.html On Dec 11, 2007 5:18 PM, kelvan wrote: > you know what you lot have left my original question this server is a > temporary piece of shit > > my original question is what are the overheads for postgres but obviously no > one knows or no one knows where a webpage containing this information is -_- So, have you looked in the docs? I go here: http://www.postgresql.org/docs/8.1/static/index.html see this down the page a bit: http://www.postgresql.org/docs/8.1/static/storage.html which takes me here: http://www.postgresql.org/docs/8.1/static/storage-page-layout.html And it seems to have that information in it. Again. You can look at the source, or find out experimentally by building tables and checking their size. Some of this is an inexact science because different architechtures have different alignment requirements.