pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Cc: pgsql-advocacy@postgresql.org
Subject: Re: [PERFORM] Presentation
Date: Wed, 8 Oct 2003 09:08:03 -0700
Message-ID: <200310080908.03864.josh@agliodbs.com> (raw)
In-Reply-To: <3F843274.30500@persistent.co.in>
References: <Pine.BSF.4.44.0310081100370.63351-100000@torgo.978.org>
	<3F843274.30500@persistent.co.in>

Shridhar,  

I'm jumping your reply to the proper mailing list.   I have one comment at the 
bottom; the rest of this quote is for the people on the Advocacy list.

> > Let me know if there are blatant errors, etc in there.
> > Maybe even slightly more subtle blatant errors :)
>
> Some minor nitpicks,
>
> * Slide 5, postgresql already features 64 bit port. The sentence is
> slightly confusing
> * Same slide. IIRC postgresql always compresses bytea/varchar. Not too much
> sure about which but there is something that is compressed by default..:-)
> * Tablespaces has a patch floating somewhere. IIRC Gavin Sherry is the one
> who is most ahead of it. For all goodness, they will feature in 7.5 and
> design is done. There aren't much issues there.
> * Mysql transaction breaks down if tables from different table types are
> involved. * Mysql transactions do not feature constant time commit/rollback
> like postgresql. The time to rollback depends upon size of transaction
> * Mysql does not split large files in segments the way postgresql do. Try
> storing 60GB of data in single mysql table.
> * Slide on informix. It would be better if you mention what database you
> were using on your pentium. Assuming postgresql is fine, but being specific
> helps. * Slide on caching. Postgresql can use 7000MB of caching. Important
> part is it does not lock that memory in it's own process space. OS can move
> around buffer cache but not memory space of an application.
> * Installation slide. We can do without 'yada' for being formal, right..:-)
> (Sorry if thats too nitpicky but couldn't help it..:-))
> * initdb could be coupled with configure/make install but again, it's a
> matter of choice.
> * Slide on configuration. 'Reliable DB corruption' is a confusing term. 'DB
> corruption for sure' or something on that line would be more appropriate
> especially if presentation is read in documentation form and not explained
> in a live session. but you decide.
> *  I doubt pg_autovacuum will be in core source but predicting that long is
> always risky..:-)
> * Using trigger for maintening a row count would generate as much dead rows
> as you wanted to avoid in first place..:-)
>
> All of them are really minor. It's a very well done presentation but 45
> slides could be bit too much at a time. I suggest splitting the
> presentation in 3. Intro and comparison, features, administration,
> programming and tuning. Wow.. they are 5..:-)
>
> Can you rip out informix migration? It could be a good guide by itself.
>
> Thanks again for documentation. After you decide what license you want to
> release it under, the team can put it on techdocs.postgresql.org..

I'd suggest just having him release it under an OSS license now.   That way, 
you can make the corrections yourself, and we can convert it to OOo and Flash 
and offer it in a variety of configurations.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



view thread (13+ messages)  latest in thread

Message-ID: <200310080908.03864.josh@agliodbs.com>
Permalink:  ../200310080908.03864.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200310080908.03864.josh@agliodbs.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: josh@agliodbs.com, shridhar_daithankar@persistent.co.in, pgsql-advocacy@postgresql.org
  Subject: Re: [PERFORM] Presentation
  In-Reply-To: <200310080908.03864.josh@agliodbs.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