recycled transaction log file: too much?

Hubert Fröhlich

Hi list,

when doing a large Insert I get in the logfile:

2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000 BD"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C2"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C3"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C4"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C5"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C6"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C7"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C8"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C1"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 BE"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 BF"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000 C0"
2004-08-03 07:39:08 LOG: recycled transaction log file "000001BA000000 C9"
This seems a bit much?! Should I try with different postgresql.conf wal
settings?

Greetings,

Hubert

--
-------------------------------------------------------------------------------
Dr.-Ing. Hubert Fröhlich
Bezirksfinanzdi rektion München
Alexandrastr. 3, D-80538 München, GERMANY
Tel. :+49 (0)89 / 2190 - 2980
Fax :+49 (0)89 / 2190 - 2997
hubert dot froehlich at bvv dot bayern dot de
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #1

Subscribe Reply

2143

Devrim GUNDUZ

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,

On Tue, 3 Aug 2004, [ISO-8859-1] Hubert Fröhlich wrote:

when doing a large Insert I get in the logfile:

2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000 BD"
<snip>
This seems a bit much?! Should I try with different postgresql.conf wal
settings?

Consider increasing wal_files in postgresql.conf , but anything beyond 5 or
10 may be painful, since each WAL file is 16MB in size.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.o rg devrim.gunduz~l inux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBD207tl8 6P3SPfQ4RAhQJAJ 0YOBAruxjzvmaxB mgbBmjPE9/zAQCfcY6T
6g58kD+artd1FG7 eF9BKZFM=
=DpIw
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 23 '05 #2

Similar topics

13342

4 Transaction Log questions

by: TZoner | last post by:

1) Can one find the location of the 'Transaction Log' at: <Hard Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf? 2) Is it safe to delete it, as SQL will create a new Transaction Log when it realises none already exist? 3) When trying to do 2) I get error message that file is in use, even though SQL Server is closed. Any suggestions? 4) Can anyone shed light on the error message 'Write on ... <my path

Microsoft SQL Server

30119

AutoShrink Transaction Log File

by: Bucfan1 | last post by:

Hello All, I have been encountering trouble with a SQL Server 2000 Transaction log file, mainly with the constant growth and lack of the autoshrink option. Here are the details: 1.) OS is Windows 2000 server sp3 2.) SQL Server 2000 (Build 2195) sp3 3.) Database Recovery Mode is set to Full 4.) Maintenance Plan for "Transaction Log Backup" is set to remove files older then 1hr.

Microsoft SQL Server

18340

Cannot shrink the transaction log

by: BashiraInTrouble | last post by:

Hi Friends, I have tried almost everything but I cant seem to shrink the transaction log. Executing DBCC SQLPERF(LOGSPACE) gives me this info: Database Log Size (MB) Log Space Used (%) Status MY_eems 368.49219 16.034182 0 I made a complete backup of the database and transaction log and then executed this statement: DBCC SHRINKFILE (MYeems_log, 1)

Microsoft SQL Server

1156

aspnet_wp.exe was recycled because memory.... error

by: kdd | last post by:

I have a ASP .NET C# web application using IIS 5.0 and .NET 1.1 on a W2K Server machine. Back-end is SQL Server 2000. When I deploy it and try to use the application/web-site I get the "aspnet_wp.exe was recycled because memory consumption exceeded 60 percent ...." error. It has * a C# dll (developed in-house) registered in global assembly cache. * several C# web services * custom web controls * 3rd party C++ dlls

ASP.NET

1644

How can I Manipulate the "Recycled Bin" ????

by: Sam Learner | last post by:

Hello, you guys have been very helpfull in responding to questions from the newgroup community and thank everyone for your contributions. I have a Question, I am developping a software to do clean up almost similar to the Clean-up Wizard... Is there any .NET classes that allow me to manipulate the Recycled bin? for example, allow me to purge a specific file in the Recycled Bin or all files there... Get a total files currently in the...

Visual Basic .NET

1804

parallel interpreter/db problem. transaction didn't fix.

by: Jim Michaels | last post by:

mysql_query("START TRANSACTION", $link2); $q2=mysql_query("SELECT pictures.pid AS pid FROM pictures,counter WHERE pictures.pid>counter.pid LIMIT 1", $link2); if ($row2=mysql_fetch_assoc($q2)) { mysql_query("UPDATE counter SET pid=$row2", $link2); $n=$row2; } else { //reached end of table. mysql_query("UPDATE counter SET pid=1", $link2);

PHP

13223

Transaction log keeps growing

by: yashgt | last post by:

Hi, We have created a SQL server 2000 database. We observe that the transaction log keeps growing over time. We are now about to run out of space. We have been periodically shrinking the database. Nevertheless the size has increased. I would imagine that a transaction log can be eliminated if we stop the database. Can that be done? Is there a way to completely wipe off the transaction log? Thanks,

Microsoft SQL Server

2700

HDD still full after shrinking transaction log

by: sifrah | last post by:

Hi All, My SQL server transaction log is getting bigger every day and my HDD if running out of space. So i follow the MS KB about how to Shrinking the Transaction Log. After doing so the log is much much smaller as i can see the size of it under enterprise manager. The problem is that the HDD still shows the same size. If i shrink the DB why the and reduce its size why the HDD does not

Microsoft SQL Server

2056

Transaction processing advice

by: Shelly | last post by:

I am looking for some advice on the design of a transaction processing sequence. As I xcurrently have it, the sequence is as follows: 1 - Gather all the information from the user other than the actual charging information. 2 - Present the user with a summary of what he is about to purchase 3 - Give him the choice of card (via PayPal) or by check. 4 - If by check, go to a screen that he has to click the "Pay" button. 5 - After the...

PHP

8989

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9537

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9367

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9319

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6795

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6073

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4599

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4869

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2780

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP