Re: Pet Peeves?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

>> * psql doesn't do multi-line readline

> I thought it started doing that in 8.2 or 8.3. At least on linux.

It combines all lines into a single statement, which is handy, but things
like this still trip it up:

psql#> CREATE <return>
psql-#> TAB <tab>

> This, very much this. I would kill to be able to have each db in a
> cluster have its own logging, settings, shared_buffers, etc. The
> whole shared mostly environment makes scaling to > 1 db on a server a
> troublesome task

Just in case you weren't aware, some settings /can/ be changed per
database with:

ALTER DATABASE prod SET random_page_cost = 2;
ALTER DATABASE fooz SET work_mem = '32 MB';

Not the logging and shared_buffers though...

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200902081214
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkmPE0IACgkQvJuQZxSWSsgk2gCeJoBSGZy6LgUZoSuNc5tGpG+y
5wAAoLndm/ggDECsNM2tFrYOsXA5TIw9
=6HJR
-----END PGP SIGNATURE-----