473,651 Members | 2,750 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Which file system do i have to choose?

Hi list,

i got an postgresql installation on linux (debian) with the htree
partitions:
1- system
2- postgresql data files
3- postgresql WAL logs(pg_xferlog )

Our standard file system is ext3. Now i heard, xfs is better for the
data files.
Is that correct, and if, why?
Or which file system is better for the postgresql installation? Do you
have preferences?

best regards,
Markus

--
Markus Rebbert <ma************ @freenet.de>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
1 3473
On Thursday 18 December 2003 17:40, Markus Rebbert wrote:
Hi list,

i got an postgresql installation on linux (debian) with the htree
partitions:
1- system
2- postgresql data files
3- postgresql WAL logs(pg_xferlog )
First of all, YMMV. reiserfs/XFS/JFS are all good and fast. Ext3 might lag
behind them in certain configurations. Besides on some RAID configs and
controllers, JFS performs better. So you really need to test.
Our standard file system is ext3. Now i heard, xfs is better for the
data files.
Is that correct, and if, why?
XFS handles large files much better. Reiserfs handles small files much
better(With V4, it is roumoured to be good all along but linux 2.6 is not yet
widespread..)

With Ext3, you need to configure correctly what you journal and how. I don't
know much about ext3 but some configs are rather slower than others. So tune
it correctly.
Or which file system is better for the postgresql installation? Do you
have preferences?


That is almost a flamebait. Best thing you can do is benchmark yourself and
determine. For help you can search archives of performance list.

Shridhar
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2926
by: Bill Burwell | last post by:
I am converting a VB6 WebClass application to VB.Net. Used the VB upgrade tool to do the conversion - and it left me a lot of little code things to do. Did those code things and got my app to compile. Did a few other code things to take advantage of .Net features not available in VB6. When I start the application on my PC I get the error shown below. It seems to me that the app initiation is failing before any app code is executed. My...
3
3324
by: hari krishna | last post by:
hi, I am generating excel reports through vb.Net. After creating excel.application and the report is generated, each report leaves Excel in memory. I can see them in task manager in Process tab (as EXCEL). So the memory has been taken by excel objects and memory is being full. i want to delete or kill this objects which are in memory. i wrote the code as 'myexcel.quit()' , myexcel=nothing. but still it is in memory. pls tell me how to...
3
3701
by: B Garrett | last post by:
Hi, I have a .ASPX page using C# and I need to read in a text file from a selected path. so in need the file dialog box to allow the user to choose the path and file that they want to read in. What command can I use todo this in a .ASPX page, I tried getting it to use windows that has the file dialog box but cannot get system.window class to be included in the project.
4
7562
by: kthiagar | last post by:
Hi I am trying to connect to a password protected access file from VB.NET. I have no problem in connecting to Access, if I remove the password. This is what I am doing: In the server explorer, I choose "Add a connection" Choose "Microsoft Jet 4.0 OLEDB Provider" in the provider tab Selected the access file in the next tab Left Username as Admin and typed the password. Now when I try to test connection, I am getting this error message:
4
4177
by: pank7 | last post by:
hi everyone, I have a program here to test the file IO(actually output) with buffer turned on and off. What I want to see is that there will be obvious differece in time. Here I have an input file scales 1.1M, what I did is just copy it to another output file(ten times). But I don't think I see any difference. My file system is ext3, with debian sarge(kernel-2.6.8). Here is the main part of my program:
3
2967
by: Lucky | last post by:
Hi guys! it's me againe! this time i'm facing some problem with the .NET 2005 IDE. i've created one "website" and i've added one webform. now i can see 2 files default.aspx and default.aspx.cs but i can see the "Windows Generated Code" in CS file. i searched for it and found that that code is written in the default.Designer.aspx.cs but what surprised me is THAT FILE DOESNT EXISTS in my project neigther in the web folder.
7
2613
by: pbd22 | last post by:
Hi. I am somewhat new to this and would like some advice. I want to search my xml file using "keyword" search and return results based on "proximity matching" - in other words, since the search string will often not produce a direct match, the results will be based on proximity (50%, 20% 100%, etc). are there any good examples out there on how to do keyword searches on XML data? How should i set up my xml file so
2
30982
by: Bruce | last post by:
I just copied the file folder containing an ASP.NET application from a backup on network share, to a new development workstation. But in the process, I've lost the .sln file. (BTW, I am accostomed moreso to .NET Windows Forms development, where the ..sln (and other metadata files) are all self-contained within the project file. In that case, I never have problems moving the project from one system or folder to another.) How do you...
4
182
by: =?Utf-8?B?Y3NsZWltYmFjaA==?= | last post by:
I am having trouble with uploading a file to a website. I can not figure what I am doing wrong. I have a .asp file that you put a username and password in that is connected to a database. One of the buttons you push is "Add Press Releasses". It prompts you to choose your file and when you select the upload button it just refreshes. Here is the code: this part works: Dim Stage Dim Count, i Dim Action
0
8275
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8802
Oralloy
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...
0
8697
jinu1996
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...
0
7297
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6158
isladogs
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...
0
5612
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();...
0
4144
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...
1
2699
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1909
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.