-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ron Johnson wrote:
> On 08/29/07 10:40, Joshua D. Drake wrote:
>> Ron Johnson wrote:
>>> Argh!!! The RDBMS that I typically use defaults to SERIALIZABLE.
>> SERIALIZABLE is really slow :). You should look into SERIALIZABLE only
>> for those transactions that need it. There is also SELECT FOR UPDATE.
>
> We use SERIALIZABLE (with all it's locking "issues") to guarantee
> the I in ACID. ISTM that READ COMMITTED can only deliver "ACD".
You are using serializable for select statements?
- ---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG1ZzQATb/zqfZUUQRAm+lAJ4i8s6I2MKCQGo1zD3g2w5lPRFikwCeNZML
4bV06CiM196qwC2l5MKqn10=
=ygzn
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
