From: Richard Huxton <dev@archonet.com>
To: kelvan <kicmcewen@windowslive.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: database tuning
Date: Tue, 11 Dec 2007 23:15:31 +0000
Message-ID: <475F1A13.2000903@archonet.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>
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
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: dev@archonet.com, kicmcewen@windowslive.com
Subject: Re: database tuning
In-Reply-To: <475F1A13.2000903@archonet.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