Re: [PERFORM] VERY slow queries at random

On 07.06.2007, at 22:42, Greg Smith wrote: On Thu, 7 Jun 2007, Gunther Mayer wrote: wal checkpoint config is on pg defaults everywhere, all relevant config options are commented out. I'm no expert in wal stuff but I don't see how that could cause the problem? Checkpoints are very resourc

Re: [PERFORM] [ADMIN] reclaiming disk space after major updates

Andrew Sullivan wrote: On Thu, Jun 07, 2007 at 03:26:56PM -0600, Dan Harris wrote: They don't always have to be in a single transaction, that's a good idea to break it up and vacuum in between, I'll consider that. Thanks If you can do it this way, it helps _a lot_. I've had to do this sort o

Re: [PERFORM] [ADMIN] reclaiming disk space after major updates

On Fri, Jun 08, 2007 at 08:29:24AM -0600, Dan Harris wrote: > > One more point in my original post.. For my own education, why does VACUUM > FULL prevent reads to a table when running (I'm sure there's a good > reason)? I can certainly understand blocking writes, but if I could still > read fr

[PERFORM] Please help me understand these numbers

I need some help. I have started taking snapshots of performance of my databases with concerns to io. I created a view on each cluster defined as: SELECT pg_database.datname AS database_name, pg_stat_get_db_blocks_fetched(pg_database.oid) AS blocks_fetched, pg_stat_get_db_blocks_hit(pg_database.

Re: [PERFORM] Please help me understand these numbers

In response to "Chris Hoover" <[EMAIL PROTECTED]>: > I need some help. I have started taking snapshots of performance of my > databases with concerns to io. I created a view on each cluster defined as: > SELECT pg_database.datname AS database_name, > pg_stat_get_db_blocks_fetched(pg_database.oi

[PERFORM] How much ram is too much

Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? Dave ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [PERFORM] How much ram is too much

What is your expected data size and usage pattern? What are the other components in the system? On Fri, 8 Jun 2007, Dave Cramer wrote: Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? Dave ---(end of broadcast)

Re: [PERFORM] How much ram is too much

Dave Cramer wrote: Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? What CPU and OS are you considering? -- Guy Rouillier ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL pr

Re: [PERFORM] Best way to delete unreferenced rows?

Craig James wrote: > Tyrrill, Ed wrote: > >> I have a table, let's call it A, whose primary key, a_id, is referenced >> in a second table, let's call it B. For each unique A.a_id there are >> generally many rows in B with the same a_id. My problem is that I want >> to delete a row in A when the l

Re: [PERFORM] dbt2 NOTPM numbers

On 6/4/07, Markus Schiltknecht <[EMAIL PROTECTED]> wrote: Thanks, that's exactly the one simple and very raw comparison value I've been looking for. (Since most of the results pages of (former?) OSDL are down). Yeah, those results pages are gone for good. :( Regards, Mark

Re: [PERFORM] Please help me understand these numbers

On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: In response to "Chris Hoover" <[EMAIL PROTECTED]>: > I need some help. I have started taking snapshots of performance of my > databases with concerns to io. I created a view on each cluster defined as: > SELECT pg_database.datname AS database_

Re: [PERFORM] How much ram is too much

It's an IBM x3850 using linux redhat 4.0 On 8-Jun-07, at 12:46 PM, Guy Rouillier wrote: Dave Cramer wrote: Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? What CPU and OS are you considering? -- Guy Rouillier -

Re: [PERFORM] How much ram is too much

On Fri, 8 Jun 2007, Dave Cramer wrote: Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? the only way 128G of ram would be too much is if your total database size (including indexes) is smaller then this. now it may not gain you as much

[OT] Re: [PERFORM] How much ram is too much

Dave Cramer írta: It's an IBM x3850 using linux redhat 4.0 Isn't that a bit old? I have a RedHat 4.2 somewhere that was bundled with Applixware 3. :-) -- -- Zoltán Böszörményi Cybertec Geschwinde & Schönig GmbH http://www.postgresql.at/ ---

Re: [PERFORM] How much ram is too much

[EMAIL PROTECTED] wrote: On Fri, 8 Jun 2007, Dave Cramer wrote: Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? the only way 128G of ram would be too much is if your total database size (including indexes) is smaller then this. now i

Re: [PERFORM] Please help me understand these numbers

On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: In response to "Chris Hoover" <[EMAIL PROTECTED]>: > On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: > > > > In response to "Chris Hoover" <[EMAIL PROTECTED]>: > > > > > I need some help. I have started taking snapshots of performance of my > >

Re: [PERFORM] Please help me understand these numbers

In response to "Chris Hoover" <[EMAIL PROTECTED]>: > On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: > > > > In response to "Chris Hoover" <[EMAIL PROTECTED]>: > > > > > I need some help. I have started taking snapshots of performance of my > > > databases with concerns to io. I created a view

Re: [OT] Re: [PERFORM] How much ram is too much

Zoltan Boszormenyi wrote: Dave Cramer írta: It's an IBM x3850 using linux redhat 4.0 Isn't that a bit old? I have a RedHat 4.2 somewhere that was bundled with Applixware 3. :-) He means redhat ES/AS 4 I assume. J -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Su

Re: [OT] Re: [PERFORM] How much ram is too much

On 8-Jun-07, at 2:10 PM, Joshua D. Drake wrote: Zoltan Boszormenyi wrote: Dave Cramer írta: It's an IBM x3850 using linux redhat 4.0 Isn't that a bit old? I have a RedHat 4.2 somewhere that was bundled with Applixware 3. :-) He means redhat ES/AS 4 I assume. Yes AS4 J -- =

Re: [OT] Re: [PERFORM] How much ram is too much

Joshua D. Drake írta: Zoltan Boszormenyi wrote: Dave Cramer írta: It's an IBM x3850 using linux redhat 4.0 Isn't that a bit old? I have a RedHat 4.2 somewhere that was bundled with Applixware 3. :-) He means redhat ES/AS 4 I assume. J I guessed that, hence the smiley. But it's very unfor

Re: [OT] Re: [PERFORM] How much ram is too much

On Fri, Jun 08, 2007 at 08:54:39PM +0200, Zoltan Boszormenyi wrote: > Joshua D. Drake írta: > >Zoltan Boszormenyi wrote: > >>Dave Cramer írta: > >>>It's an IBM x3850 using linux redhat 4.0 > >>Isn't that a bit old? I have a RedHat 4.2 somewhere > >>that was bundled with Applixware 3. :-) > >He mean

Re: [OT] Re: [PERFORM] How much ram is too much

[EMAIL PROTECTED] írta: On Fri, Jun 08, 2007 at 08:54:39PM +0200, Zoltan Boszormenyi wrote: Joshua D. Drake írta: Zoltan Boszormenyi wrote: Dave Cramer írta: It's an IBM x3850 using linux redhat 4.0 Isn't that a bit old? I have a RedHat 4.2 somewhere that w

Re: [PERFORM] How much ram is too much

Dave Cramer wrote: It's an IBM x3850 using linux redhat 4.0 I had to look that up, web site says it is a 4-processor, dual-core (so 8 cores) Intel Xeon system. It also says "Up to 64GB DDR II ECC memory", so are you sure you can even get 128 GB RAM? If you could, I'd expect diminishing ret

Re: [OT] Re: [PERFORM] How much ram is too much

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Zoltan Boszormenyi wrote: > Joshua D. Drake írta: >> Zoltan Boszormenyi wrote: >>> Dave Cramer írta: It's an IBM x3850 using linux redhat 4.0 >>> >>> Isn't that a bit old? I have a RedHat 4.2 somewhere >>> that was bundled with Applixware 3. :-)