Re: Proposed Change for 1.3

["Joshua D. Drake" <..hidden..>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 2 Apr 2008 13:56:28 -0700
"Chris Travers" <..hidden..> wrote:

> The major drawback is that anything which hits this field needs to
> join against the (much-larger) acc_trans table.  This means that
> there is a performance cost in large installations where these fields
> are used (AP/AP Reports, payment handling, etc).  It should not
> affect most areas reports or data entry, however.

I would think the performance hit would be nominal except in the
largest of cases.

Joshua D. Drake

- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH8/doATb/zqfZUUQRAkb/AKCAGcCWh6DXi5DwLMq00QWATSBr9QCfd85l
yWsaQnN9/+yIB0X4tXpU75o=
=JGwU
-----END PGP SIGNATURE-----