Am Montag, den 17.01.2005, 17:47 -0800 schrieb Jeff Davis:
> On Tue, 2005-01-18 at 07:43 +0700, David Garamond wrote:
> > Tzahi Fadida wrote:
> > > I recommend you don't use ext3 for any database:
> > > http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> > >
> > > apparently its still bugg
Hi,
Am Dienstag, den 18.01.2005, 07:43 +0700 schrieb David Garamond:
> Tzahi Fadida wrote:
> > I recommend you don't use ext3 for any database:
> > http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> >
> > apparently its still buggy.
>
> So what is the recommended fs under Linux? I don't
Jeff Davis <[EMAIL PROTECTED]> writes:
> In other words, does PostgreSQL assume that the filesystem at least
> journals the metadata?
Postgres assumes that the filesystem can take care of itself, which we
define as not losing or corrupting successfully-fsynced data. The
original BSD filesystem de
You may also want to test data=journal for ext3. Most of the time, this
is slower but for databases with logging and mail servers, it can be faster.
Mage wrote:
Hello,
Gabor Szima asked us to translate the letter below.
"I read that ext3 writeback mode is recommended for PostgreSQL. I ma
On Tue, 2005-01-18 at 07:43 +0700, David Garamond wrote:
> Tzahi Fadida wrote:
> > I recommend you don't use ext3 for any database:
> > http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> >
> > apparently its still buggy.
>
> So what is the recommended fs under Linux? I don't need the bes
On Mon, 17 Jan 2005 16:54:45 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> David Garamond wrote:
>
> > Tzahi Fadida wrote:
> >
> >> I recommend you don't use ext3 for any database:
> >> http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> >>
> >> apparently its still buggy.
> >
> >
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I typically use XFS when given the choice.
On Jan 17, 2005, at 7:52 PM, Rich Shepard wrote:
On Tue, 18 Jan 2005, David Garamond wrote:
So what is the recommended fs under Linux? I don't need the best
speed/throughput, but I prefer not to use ext2 due to
David Garamond wrote:
Tzahi Fadida wrote:
I recommend you don't use ext3 for any database:
http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
apparently its still buggy.
So what is the recommended fs under Linux? I don't need the best
speed/throughput, but I prefer not to use ext2 due to l
On Tue, 18 Jan 2005, David Garamond wrote:
> So what is the recommended fs under Linux? I don't need the best
> speed/throughput, but I prefer not to use ext2 due to long fsck time. I
> also tend to avoid reiser3, it has given us many griefs in the past. XFS?
dave,
I have no large databases h
Tzahi Fadida wrote:
I recommend you don't use ext3 for any database:
http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
apparently its still buggy.
So what is the recommended fs under Linux? I don't need the best
speed/throughput, but I prefer not to use ext2 due to long fsck time. I
also
Gabor Szima asked us to translate the letter below.
"I read that ext3 writeback mode is recommended for PostgreSQL. I made
some tests.
data=ordereddata=writeback
--
restoredb: 2m16.790s
anuary 17, 2005 9:01 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] ext3
>
>
> Hello,
>
> Gabor Szima asked us to translate the letter below.
>
> "I read that ext3 writeback mode is recommended for
> PostgreSQL. I made
> some tests.
On Mon, 17 Jan 2005 20:00:46 +0100, Mage <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Gabor Szima asked us to translate the letter below.
>
> "I read that ext3 writeback mode is recommended for PostgreSQL. I made
> some tests.
>
> data=ordereddata=writeback
> ---
Hello,
Gabor Szima asked us to translate the letter below.
"I read that ext3 writeback mode is recommended for PostgreSQL. I made
some tests.
data=ordereddata=writeback
--
restoredb: 2m
We're running on ext2 on our box, with nightly backups. There's not much
in the database we can't recreate from feeds, and we aren't doing
financials on it. I've also heard of Reiser having had some problems on
SMP systems.
Of course, our box hasn't gone down unexpectedly ever, either due to O
It was RH8 where I saw the issues. It was so bad that I had one server
freeze 20 minutes after reboot. And it wasn't a hardware issue; that
server is now running with several months of uptime under heavy load.
Jonathan Bartlett wrote:
What distribution are you running? I and a lot of other pe
hello.
my database size is 5GB. what is the block size
recommend?
thanks
wilson
Don't know the answer to your question, but I thought I would just pipe
in and say that if this is an SMP (has multiple processors) Linux box
you don't want to use ext3!!!
I used ext3 on my SMP box here at work and now I can't have children (I
guess it would help if I got a wife first)!!
But i
18 matches
Mail list logo
