| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ben Chobot <bench(at)silentmedia(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: vacuum issues under load? |
| Date: | 2010-01-18 07:28:18 |
| Message-ID: | 20100118072818.GC31949@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 15, 2010 at 08:41:38AM -0700, Scott Marlowe wrote:
> With slony 2.0.3 or so, I had occasional complete lockups of my
> database that I didn't have time to troubleshoot as it was a live
> cluster and I had to restart slony and the databases to get them back
> up and running.
With slony 2.0.2 I had similar problems. A CREATE INDEX on the slave
caused slony on the slave to block while inserting into the table which
eventually blocked the server during the log switch (TRUNCATE) which
eventually blocked everything else.
It occurs to me that the slony daemon should be able to get the
TRUNCATE command to abort if it takes too long.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian | 2010-01-18 07:45:21 | does ispell have allaffixes set to on? |
| Previous Message | David Fetter | 2010-01-18 07:25:02 | Re: postgres external table |