Skip site navigation (1) Skip section navigation (2)

Re: database tuning

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: kelvan <kicmcewen(at)windowslive(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: database tuning
Date: 2007-12-11 22:29:59
Message-ID: dcc563d10712111429i3100d4d3iba2fb76f005e528a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
http://www.postgresql.org/docs/8.1/static/storage.html

On Dec 11, 2007 5:18 PM, kelvan <kicmcewen(at)windowslive(dot)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.

In response to

pgsql-performance by date

Next:From: Erik JonesDate: 2007-12-11 22:34:01
Subject: Re: database tuning
Previous:From: Alvaro HerreraDate: 2007-12-11 22:27:48
Subject: Re: database tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group