...and on Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus used the keyboard:
>
> Does it work, though? Without Oracle admin tools?
Hello, Josh. :)
Well, as I said, that's why I was asking - I'm willing to give it a go
if nobody can prove me wrong. :)
> > Now, if both goals can be achieved
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> But it should be okay to set the filesystem to journal only its own
> >> metadata. There's no need for it to journal file contents.
>
> > Can you set ext2 to journal metadata? I didn't know it could do that.
>
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> But it should be okay to set the filesystem to journal only its own
>> metadata. There's no need for it to journal file contents.
> Can you set ext2 to journal metadata? I didn't know it could do that.
No, ext2 has no journal at all
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > scott.marlowe wrote:
> >>> There is no real need (or benefit) from having the database on a
> >>> journalled filesystem - the journalling is only trying to give similar
> >>> sorts of guarantees to what the fsync in PostgreSQL is doing
Bruce Momjian <[EMAIL PROTECTED]> writes:
> scott.marlowe wrote:
>>> There is no real need (or benefit) from having the database on a
>>> journalled filesystem - the journalling is only trying to give similar
>>> sorts of guarantees to what the fsync in PostgreSQL is doing.
>>
>> Is this true? I
On 07/04/2004 22:05 Jaime Casanova wrote:
What the statistics are? Where can i view it? where can i find info
about its field and why are they valuable information to performance?
thanx in advance,
Jaime Casanova
OK. An idiot's guide to statistics by a full-time idiot...
Let's start with a si
scott.marlowe wrote:
> > One thing I recommend is to use ext2 (or almost anything but ext3).
> > There is no real need (or benefit) from having the database on a
> > journalled filesystem - the journalling is only trying to give similar
> > sorts of guarantees to what the fsync in PostgreSQL is do
What the statistics are? Where can i view it? where can i find info about
its field and why are they valuable information to performance?
thanx in advance,
Jaime Casanova
_
Protect your PC - get McAfee.com VirusScan Online
http://
On Wed, 7 Apr 2004, Nid wrote:
> Rather than ask some general, unanswerable question on how to tune my
> database...I thought I ask where I might find an introduction to...or
> manual/tutorial for the depths of managing a postgres db. Books?
> Websites? Assume a basic to intermediate knowled
On Wed, 7 Apr 2004, Andrew McMillan wrote:
> On Wed, 2004-04-07 at 20:56, huang yaqin wrote:
> > Hello, Richard Huxton,
> >
> > You said turning fsync off may cause losing data, that's terrible.
> > I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't ge
Rather than ask some general, unanswerable question
on how to tune my database...I thought I ask where I might find an introduction
to...or manual/tutorial for the depths of managing a postgres db.
Books? Websites? Assume a basic to intermediate knowledge of DBs in
general with a desire t
On Mon, 2004-04-05 at 11:36, Josh Berkus wrote:
> Unfortunately, these days only Tom and Neil seem to be seriously working on
> the query planner (beg pardon in advance if I've missed someone)
Actually, Tom is the only person actively working on the planner --
while I hope to contribute to it in
On Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus wrote:
> If your intention in this test is to show the superiority of raw devices, let
> me give you a reality check: barring some major corporate backing getting
> involved, we can't possibly implement our own PG-FS for database support. We
Grega,
> Furthermore, this filesystem would be a blazing one stop solution for
> all replication issues PostgreSQL currently suffers from, as its main
> design goal was to present "a consistent file system image across the
> servers in a cluster".
Does it work, though? Without Oracle admin tool
fsync I'm thinking 50 inserts, if autocommiting is 50TPS = ~100 IO per
second (50 WAL + checkpoint IO) = roughly the I/O rate of a single drive.
Huang - Are you using a single drive for pg? If so, there is a safety
problem of both the data and logs used for recovery on the same drive. If
the drive
On Wednesday 07 April 2004 10:03, Ken Geis wrote:
> Richard Huxton wrote:
> > On Tuesday 06 April 2004 21:25, Ken Geis wrote:
> >>I am trying to find an efficient way to draw a random sample from a
> >>complex query. I also want it to be easy to use within my application.
> >>
> >>So I've defined
Sending again bacuse of MUA error.. Chose a wrong address in From..:-(
Shridhar
On Wednesday 07 April 2004 17:21, Shridhar Daithankar wrote:
> On Wednesday 07 April 2004 16:59, Andrew McMillan wrote:
> > One thing I recommend is to use ext2 (or almost anything but ext3).
> > There is no real nee
On Wed, 2004-04-07 at 20:56, huang yaqin wrote:
> Hello, Richard Huxton,
>
> You said turning fsync off may cause losing data, that's terrible.
> I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
> any improvement. So what can I do?
>
It sounds almost like you're doing one insert per transaction. Try wrapping
multiple inserts into a single transaction and see if that helps. This may
not be appropriate for your application, but it does guarantee that
committed transactions will not be lost.
My apologies if you are already doin
On Wed, 7 Apr 2004, huang yaqin wrote:
> You said turning fsync off may cause losing data, that's terrible. I use
> SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
> any improvement. So what can I do?
Make sure you do as much as possible inside one transaction. If you wan
Richard Huxton wrote:
On Tuesday 06 April 2004 21:25, Ken Geis wrote:
I am trying to find an efficient way to draw a random sample from a
complex query. I also want it to be easy to use within my application.
So I've defined a view that encapsulates the query. The id in the
"driving" table is ex
Hello, Richard Huxton,
You said turning fsync off may cause losing data, that's terrible.
I use SCSI disk, and file system is ext3. I tune postgresql.conf and can't get
any improvement. So what can I do?
Does SCSI disk and IDE disk have difference?
On Tuesday 06 April 2004 21:25, Ken Geis wrote:
> I am trying to find an efficient way to draw a random sample from a
> complex query. I also want it to be easy to use within my application.
>
> So I've defined a view that encapsulates the query. The id in the
> "driving" table is exposed, and I
On Wednesday 07 April 2004 05:00, huang yaqin wrote:
> hello！
>
> Thanks, you are right.
>I use "postmaster -o "-F" " to start my PG，and performance improved
> greatly.
I don't think Tom was recommending turning fsync off. If you have a system
crash/power glitch then the database ca
...and on Wed, Apr 07, 2004 at 01:26:02AM -0400, Tom Lane used the keyboard:
>
> After that, we get to implement our own filesystem-equivalent management
> of disk space allocation, disk I/O scheduling, etc. Are we really
> smarter than all those kernel hackers doing this for a living? I doubt i
hi shridhar,
> Heiko Kehlenbrink wrote:
>
>> hi list,
>>
>> i want to convince people to use postgresql instead of ms-sql server, so i
>> set up a kind of comparission insert data / select data from postgresql /
>> ms-sql server
>>
>> the table i use was pretty basic,
>>
>> id bigserial
>> dist
26 matches
Mail list logo
