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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
