Search Postgresql Archives

Re: Missing Toast Chunk

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sorry, I forgot to mention that we also tried reindexing the toast table.

On Thu, Aug 19, 2010 at 1:20 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
SNIP

It's almost certainly not ruby's fault.  Have they done anything
strange like kill the instance and restart it without letting the db
shut down?  I'd tend to suspect Amazon's fsyncing is amiss and they
did something that triggered it.

--
To understand recursion, one must first understand recursion.

They haven't done anything like that, that we know of.  However, they do have a process that kills off all waiting (and only waiting) postgres processes if there are more than 1000 locks.  Could that be an issue?

If Amazon's fsyncing is the problem and they're doing something to trigger it, how would we go about debugging that?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux