[ADMIN] performance problem

[sanjay tumula]

the problem is solved...
once i reverted back to 9.1...things seems to be much better.
i also revamped a lot of my code to optimize it for speed.
will post the results after i complete a sizable chunk of my data.
the in also seems to working much better now...
thanx
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faq

Re: [ADMIN] database corruption

[Amadeus Zilfinski]

,snipped.
> - SuSE 9.1
> - 2.6.6 kernel
> - Postgres 7.4.2
> - 300 TPS against DB containing 5-50GB data, no more than a dozen
>   concurrent connections.
> - fsync (or not) and fdatasync

I remember a problem that was fixed in the 2.6.9 kernel concerning XFS
corruption (shutdowns I think were the worst). Also introduced some JFS
stuff, but I don't run JFS so I didn't really pay much attention to
that.

Can you try a later (the latest?) vanilla kernel?

AmadeusZ.-


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly

Re: [ADMIN] Help installing 8.0.2 rpms on RH 3.0

[Joel Fradkin]

Not sure if they were updated, but we (James from Dell, I watched) did
remove all the 8.0.1 rpms and install 8.0.2 just fine.

Joel Fradkin
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chris Hoover
Sent: Friday, April 15, 2005 4:49 PM
To: Tom Lane
Cc: PostgreSQL Admin
Subject: Re: [ADMIN] Help installing 8.0.2 rpms on RH 3.0

Tom Lane wrote:

>"Chris Hoover" <[EMAIL PROTECTED]> writes:
>  
>
>>... However, I am having some difficulty installing the
>>postgresql.org RH 3.0 rpms for Postgresql 8.0.2.
>>
>>
>
>Up until really recently (read: not yet shipped for Red Hat, and I'm
>not sure about the PGDG RPMs), the 8.0 RPMs had the wrong Obsoletes:
>data in them for replacing rh-postgresql RPMs with later postgresql
>RPMs.  So I'd definitely suggest removing *all* the rh-postgresql RPMs
>before you try to install newer stuff.  It wasn't real clear whether
>that was the sum total of your problem however...
>
>  
>
>>Virgin install of RH ES 3.0 from cd's (no update run right now)
>>
>>
>
>It wouldn't be a bad idea to do "up2date" first.  For all you know
>you are fighting a bug in RPM itself.
>
>   regards, tom lane
>
>
>
>
>  
>
Tom,

It looks like it is a specific problem with the 8.0.2 rpms.  Below is
what I wrote about trying the 8.0.1 rpms.

Ok, I thought I'd try the 8.0.1 rpms just for giggles.  I was able to
install the postgresql-libs rpm for 8.0.1 with out a problem.  It looks
like there is a bug in the 8.0.2 if you are installing from scratch.
Can someone please point me to the proper place to log this bug.

(sorry for the delay in response, I had some mail problems with my isp)

Chris




---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])