pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: kelvan <kicmcewen@windowslive.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: database tuning
Date: Tue, 11 Dec 2007 16:29:59 -0600
Message-ID: <dcc563d10712111429i3100d4d3iba2fb76f005e528a@mail.gmail.com> (raw)
In-Reply-To: <fjn2d5$5al$1@news.hub.org>
References: <fja1je$2c22$1@news.hub.org>
	<1197016760.4255.474.camel@ebony.site>
	<fjc2hb$2cd3$1@news.hub.org>
	<dcc563d10712100858j7b55e68co5d0da0f8b82c19b1@mail.gmail.com>
	<fjki5a$uf1$1@news.hub.org>
	<Pine.GSO.4.64.0712101912340.14776@westnet.com>
	<fjn2d5$5al$1@news.hub.org>

http://www.postgresql.org/docs/8.1/static/storage.html

On Dec 11, 2007 5:18 PM, kelvan <kicmcewen@windowslive.com> 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.



view thread (19+ messages)  latest in thread

Message-ID: <dcc563d10712111429i3100d4d3iba2fb76f005e528a@mail.gmail.com>
Permalink:  ../dcc563d10712111429i3100d4d3iba2fb76f005e528a@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10712111429i3100d4d3iba2fb76f005e528a@mail.gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: scott.marlowe@gmail.com, kicmcewen@windowslive.com
  Subject: Re: database tuning
  In-Reply-To: <dcc563d10712111429i3100d4d3iba2fb76f005e528a@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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