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

Re: database tuning

From: Richard Huxton <dev(at)archonet(dot)com>
To: kelvan <kicmcewen(at)windowslive(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: database tuning
Date: 2007-12-11 23:15:31
Message-ID: 475F1A13.2000903@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 -_-
> 
> overhead information i would to know is row overheads column overheads and 
> header overheads for blocks and anything else i have missed

You said you had most of that in your original post:
 > I have gathered some relevant information form the documentation such 
 > as all
 > the data type sizes and the RM block information but I don't have any
 > information on INDEX blocks or other general overheads

The index details are in the source, as I said in my first reply. It's 
just that nobody here thinks that'll help you much.

> neither I nor the web app developer are Mac savvy hell as far as we have 
> seen no Mac tec is Mac savvy either

So what on earth are you going to do with the index overhead figures? 
Without accurate information on usage patterns, fill-factor, vacuuming 
frequency etc. they aren't going to tell you anything.

Even if you could get an accurate figure for database size with less 
effort than just generating test data, what would your next step be?

> as I have said your ideas sound good just not Mac oriented 

The only idea I've seen mentioned is connection-pooling. I'm not sure 
why that wouldn't work on a Mac.

Other comments were warning that 30,000 connections weren't do-able, 
that de-normalising made poor use of your limited disk/memory and 
pointing out solutions other people use.

Oh, and me asking for any info from your testing.

 > nor are they to
> do with my original question I have never had trouble finding overhead 
> information on any other DBMS I have used this is the first time I have had 
> to ask for it and since this DBMS is open source I have to ask a community 
> rather than a company

Again, since you said you had all the stuff from the manuals, the rest 
is in the source. That's what the source is there for.

-- 
   Richard Huxton
   Archonet Ltd

In response to

pgsql-performance by date

Next:From: kelvanDate: 2007-12-11 23:18:42
Subject: Re: database tuning
Previous:From: Erik JonesDate: 2007-12-11 22:34:01
Subject: Re: database tuning

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