Re: [PERFORM] Performance of Seq Scan from buffer cache

2012-08-23 Thread Merlin Moncure
On Tue, Aug 21, 2012 at 6:59 PM, Matt Daw wrote: > Ugh, never mind. I ran ltrace and it's spending 99% of its time in > gettimeofday. yeah -- this is a fairly common report. some systems (windows) have a less accurate but much faster gettimeofday(). merlin -- Sent via pgsql-performance maili

Re: [PERFORM] Increasing WAL usage followed by sudden drop

2012-08-23 Thread delongboy
Jeff Janes wrote > > It seems like it shouldn't be all that hard to write a tool to parse > WAL logs in a context-free basis (i.e. without the backup to start > applying them to) and emit some kind of descriptions of the records > and their sizes. But I don't know about such a tool already exist