Re: [SQL] can this be done with a check expression?

2012-08-08 Thread Wayne Cuddy
I'm seeing this in my PGSQL logs, is this something to be concerned about? I know the file system it sits on is reliable and the DB appears to run with fine, additionally the log indicates it's a debug message. I did some google searches and didn't find much. When I examine the file system file by

Re: [SQL] can this be done with a check expression?

2012-08-08 Thread Wayne Cuddy
This was posted under the wrong subject.. Please ignore, will repost. On Wed, Aug 08, 2012 at 11:41:01AM -0400, Wayne Cuddy wrote: > I'm seeing this in my PGSQL logs, is this something to be concerned > about? I know the file system it sits on is reliable and the DB appears > to run with fine, add

[SQL] fsync debug messages in pgsql logs

2012-08-08 Thread Wayne Cuddy
I'm seeing this in my PGSQL logs, is this something to be concerned about? I know the file system it sits on is reliable and the DB appears to run with fine, additionally the log indicates it's a debug message. I did some google searches and didn't find much. When I examine the file system file by

Re: [SQL] fsync debug messages in pgsql logs

2012-08-08 Thread Tom Lane
Wayne Cuddy writes: > I'm seeing this in my PGSQL logs, is this something to be concerned > about? I know the file system it sits on is reliable and the DB appears > to run with fine, additionally the log indicates it's a debug message. I > did some google searches and didn't find much. > When I e

Re: [SQL] fsync debug messages in pgsql logs

2012-08-08 Thread Wayne Cuddy
On Wed, Aug 08, 2012 at 12:23:22PM -0400, Tom Lane wrote: > Wayne Cuddy writes: > > I'm seeing this in my PGSQL logs, is this something to be concerned > > about? I know the file system it sits on is reliable and the DB appears > > to run with fine, additionally the log indicates it's a debug mess

Re: [SQL] fsync debug messages in pgsql logs

2012-08-08 Thread Tom Lane
Wayne Cuddy writes: > On Wed, Aug 08, 2012 at 12:23:22PM -0400, Tom Lane wrote: >> If it only complains once per file name, this is expected behavior when >> somebody drops a table just before the checkpoint mechanism tries to >> fsync it. (If the failure were to repeat, then it might be somethin

Re: [SQL] fsync debug messages in pgsql logs

2012-08-08 Thread Wayne Cuddy
Ok, I'll keep an eye on it but I'm not so worried now. Thanks Tom. On Wed, Aug 08, 2012 at 12:57:01PM -0400, Tom Lane wrote: > Wayne Cuddy writes: > > On Wed, Aug 08, 2012 at 12:23:22PM -0400, Tom Lane wrote: > >> If it only complains once per file name, this is expected behavior when > >> some