OK i'm showing my ignorance of linux. On Ubuntu i can't seem to figure
out if XFS file system is installed, if not installed getting it
installed.
I would like to see the difference between XFS and ext2 performance
numbers.
any pointers would be nice. I 'm not going to reinstall the OS.
Tom Lane wrote:
>> On a database (PostgreSQL 8.2.4 on 64-bit Linux 2.6.18 on 8 AMD Opterons)
>> that is under high load, I observe the following: ...
>> - "vmstat" shows that CPU time is divided between "idle" and "iowait",
>> with user and sys time practically zero.
>> - "sar" says that the disk
Justin wrote:
OK i'm showing my ignorance of linux. On Ubuntu i can't seem to figure
out if XFS file system is installed, if not installed getting it
installed.
Hm? Installed/not installed? You can select that when you are preparing
your partitions. If you run the automated partitioner ther
On 17/03/2008, Justin <[EMAIL PROTECTED]> wrote:
> OK i'm showing my ignorance of linux. On Ubuntu i can't seem to figure
> out if XFS file system is installed, if not installed getting it
> installed.
...
> any pointers would be nice. I 'm not going to reinstall the OS. Nor do
> i want to
Justin wrote:
> OK i'm showing my ignorance of linux. On Ubuntu i can't seem to figure
> out if XFS file system is installed, if not installed getting it
> installed.
There are two parts to the file system, really. One is the kernel driver
for the file system. This is almost certainly available
hi all,
I want this mail to be continued about summary of performance tuning
tools... or other postgres related tools..
I ll start with saying there is a tool SCHEMASPY ( i got to know about this
from this group only ), this will draw ER diagram and gives interesting
informations about our postgre
Toad Data Modeler from Quest Software is an E/R diagram tool that works for
us.
And - it has a freeware version.
Mark Steben
Senior Database Administrator
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate
Well every thing worked right up to the point where i tried to mount the
file system
Warning: xfs_db: /dev/sdb1 contains a mounted file system
fatal error -- couldn't initialize XFS library.
think i'm missing something???
Craig Ringer wrote:
Justin wrote:
OK i'm showing my ignorance of
i thought many a replies will come... but only one..
common guys... it may be helping you in tuning your database indirectly,
post that tool also, give some informations such as
Tool Name: Schemaspy
Open Source: YES
Database: Postgres
URL: http://sourceforge.net/projects/schemaspy/1
Following can
Have you tried the archive search tool for this very mailing list?
There's a wealth of information imparted all the time, and tuning is
generally about knowledge of what's happening, not blindly following
the output of some program.
On Mar 17, 2008, at 8:46 AM, sathiya psql wrote:
i thou
On 17-Mar-08, at 2:50 PM, Justin wrote:
Just out of curiosity: Last time I did research, the word seemed to
be that xfs was better than ext2 or ext3. Is that not true? Why
use ext2/3 at all if xfs is faster for Postgres?
Criag
Ext2 vs XFS on my setup there is difference in the perf
2000 tps ??? do you have fsync turned off ?
Dave
No its turned on.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
> > I am going to embarkon building a music library using apache,
> > postgresql and php. What is the best way to store the music files?
>
> Your options are either to use a BLOB within the database or to store
> paths to normal files in the file system in the database. I suspect
> using norm
Justin wrote:
2000 tps ??? do you have fsync turned off ?
Dave
No its turned on.
Unless I'm seriously confused, something is wrong with these numbers. That's
the sort of performance you expect from a good-sized RAID 10 six-disk array.
With a single 7200 rpm SATA disk and XFS, I get 640
Craig James wrote:
Justin wrote:
2000 tps ??? do you have fsync turned off ?
Dave
No its turned on.
Unless I'm seriously confused, something is wrong with these numbers.
That's the sort of performance you expect from a good-sized RAID 10
six-disk array. With a single 7200 rpm SATA di
On Mon, Mar 17, 2008 at 2:01 PM, Peter Koczan <[EMAIL PROTECTED]> wrote:
> > > I am going to embarkon building a music library using apache,
> > > postgresql and php. What is the best way to store the music files?
> >
> > Your options are either to use a BLOB within the database or to store
On Sun, Mar 16, 2008 at 2:25 AM, Craig Ringer
<[EMAIL PROTECTED]> wrote:
> Rich wrote:
> > I am going to embarkon building a music library using apache,
> > postgresql and php. What is the best way to store the music files?
>
> Your options are either to use a BLOB within the database or to sto
Just out of curiosity: Last time I did research, the word seemed to be
that xfs was better than ext2 or ext3. Is that not true? Why use
ext2/3 at all if xfs is faster for Postgres?
Criag
Ext2 vs XFS on my setup there is difference in the performance between
the two file systems but its
Hi Justin,
Il giorno 17/mar/08, alle ore 20:38, Justin ha scritto:
it is a RAID 10 controller with 6 SAS 10K 73 gig drives.The
server is 3 weeks old now.
it has 16 gigs of RAM
2 quad core Xenon 1.88 Ghz processors
2 gig Ethernet cards. RAID controller perc 6/i with battery backup
512meg
On Mon, Mar 17, 2008 at 2:58 PM, Enrico Sirola <[EMAIL PROTECTED]> wrote:
> Hi Justin,
>
> Il giorno 17/mar/08, alle ore 20:38, Justin ha scritto:
>
> > it is a RAID 10 controller with 6 SAS 10K 73 gig drives.The
> > server is 3 weeks old now.
> >
> > it has 16 gigs of RAM
> > 2 quad core
On 18/03/2008, sathiya psql <[EMAIL PROTECTED]> wrote:
> i thought many a replies will come... but only one..
You *ARE* aware of the fact that many people on this planet
aren't in your time-zone, eh? And as Ben pointed out: there's
been a good lot of similar questions - people who want to know
can
I have _not_ added a TODO for this item. Let me know if one is needed.
---
Tom Lane wrote:
> Ron Mayer <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> There's something fishy about this --- given that that plan has a l
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I have _not_ added a TODO for this item. Let me know if one is needed.
Please do, I think it's an open issue.
* Consider Cartesian joins when both relations are needed to form an
indexscan qualification for a third relation
r
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I have _not_ added a TODO for this item. Let me know if one is needed.
>
> Please do, I think it's an open issue.
>
> * Consider Cartesian joins when both relations are needed to form an
> indexscan qualification for a third relat
All that helps to pgsql to perform good in a TB-sized database
enviroment is a Good Think (r) :D
Pablo
Bruce Momjian wrote:
I have _not_ added a TODO for this item. Let me know if one is needed.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes t
Hi,
ok, what about Squirrel-Sql ?
Tool Name: Squirrel sql
Free software: YES
URL: http://squirrel-sql.sourceforge.net/
Java multi-rdbms sql client.
Run on Linux, Windows, ...
Easily Installable: YES
Performance TUNING tool: don't know what this means :)
ER diagram tool: Yes
Query Analysis Tool:
> It seems to me as such a database gets larger, it will become much harder to
> manage with the 2 systems. I am talking mostly about music. So each song
> should not get too large.
I was just talking about points to consider in general. Getting to
your specific situation...
As far as BLOBs
Tom Lane wrote:
Bruce Momjian <[EMAIL PROTECTED]> writes:
I have _not_ added a TODO for this item. Let me know if one is needed.
Please do, I think it's an open issue.
* Consider Cartesian joins when both relations are needed to form an
indexscan qualification for a third relation
Woul
28 matches
Mail list logo
