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

Re: Pet Peeves?

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-29 20:32:54
Message-ID: 49821276.20407@cheapcomplexdevices.com (view raw or flat)
Thread:
Lists: pgsql-general
Gregory Stark wrote:
> I'm putting together a talk on "PostgreSQL Pet Peeves" for discussion at
> FOSDEM 2009 this year. I have a pretty good idea what some them are of course,


* The capitalization that makes everyone (customers, execs, etc) I introduce
  it to parse the name as Postgre-SQL.


* Last I checked, postgres keeps my laptop's hard drive spinning all the time
  by doing some I/O even when "totally idle".  For that matter, waking
  up the CPUs a few times a second too.

* pgfoundry - which was once described on the mailinglists as
  the "kiss of death" for projects.   Yes, I understand why it is
  what it is; but it's still a pet-peeve.   I can't even put my finger
  on what's annoying about it; but it is.

* Upgrades involving databases with extra modules like postgis.
  $ sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump -E=UNICODE

* Finding extensions I might want.  For example:
  - Surely someone wrote a good count(*)-replacement-trigger before.
    Now where can I find one?  Searching for "count" on pgfoundry
    doesn't help me.   Searching varlena genralbits find shows me
    a simple one, but IIRC is lacking when it comes to concurrency.
    Googling just gets me lots of "read the archives" postings in
    the archives.


In response to

  • Pet Peeves? at 2009-01-29 13:16:17 from Gregory Stark

Responses

pgsql-general by date

Next:From: Karsten HilbertDate: 2009-01-29 20:43:38
Subject: Re: Pet Peeves?
Previous:From: hubert depesz lubaczewskiDate: 2009-01-29 20:29:42
Subject: Re: Pet Peeves?

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