Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Unanswered: why write ahead logs in postgresql are generated every second

    In my Postgresql (9.2 version) generates write ahead log (WAL) of 16MB for everysecond i.e. 60 WALs are generated in One Minute., though no transactions in the database
    Can it possible to make them occur less frequency.
    Can it possible to increase the WAL file size, so that less WALs will generate in One minute

    any insights are welcomed..

    Thanks in advance

    regards

  2. #2
    Join Date
    Mar 2014
    Posts
    17
    Quote Originally Posted by nsammu View Post
    In my Postgresql (9.2 version) generates write ahead log (WAL) of 16MB for everysecond i.e. 60 WALs are generated in One Minute., though no transactions in the database
    Can it possible to make them occur less frequency.
    Can it possible to increase the WAL file size, so that less WALs will generate in One minute

    any insights are welcomed..

    Thanks in advance

    regards
    WHats ur values for "WAL_SYNC_METHOD" and WAL_LEVEL ?

  3. #3
    Join Date
    Apr 2014
    Posts
    2
    Quote Originally Posted by BhuvneshDogra View Post
    WHats ur values for "WAL_SYNC_METHOD" and WAL_LEVEL ?
    WAL_LEVEL = 'hot_standby'

    WAL_SYNC_METHOD is default value

  4. #4
    Join Date
    Mar 2014
    Posts
    17

  5. #5
    Join Date
    Mar 2014
    Posts
    20
    And check that haven't set your archive_timeout = 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •