[ADMIN] a warm standby takes over, hot standby does not catch up

2011-04-23 Thread bo gu
Recently, I crafted my site like this to achieve HA and load balancing: -- | Apache | | | | | read | .. many of this |

Re: [ADMIN] DELETE FROM pg_description WHERE ...

2011-04-23 Thread Erwin Brandstetter
On 23.04.2011 05:21, Tom Lane wrote: Erwin Brandstetterbrsaw...@gmail.com writes: However, I have a database with dozens of schemas and hundreds of tables. There is a bunch of useless comments on columns I want to get rid of, scattered all across the db. The fastest easiest way would be:

Re: [ADMIN] select for update

2011-04-23 Thread Craig James
On 4/22/11 8:17 PM, Tom Lane wrote: Craig Jamescraig_ja...@emolecules.com writes: On 4/22/11 1:58 PM, Tom Lane wrote: Craig Jamescraig_ja...@emolecules.com writes: select objectid from archive where db_id is null limit 1 for update The interaction between LIMIT and FOR UPDATE changed in