]8.3G ./base[PARA]4.0K ./pg_tblspc[PARA]588K ./pg_log[PARA]8.8G .
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2006 12:20 PM
To: mcelroy, tim
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] pg_dump issue
"m
the Engineering staff can find something system related as I doubted and still doubt that it's a postgres issue.
Tim
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2006 11:16 AM
To: mcelroy, tim
Cc: pgsql-performance@postgresql.or
Title: pg_dump issue
Good morning,
I have identical postgres installations running on identical machines. Dual Core AMD Opteron(tm) Processor 870 , 16GB RAM, Red Hat Linux 3.2.3-20 and 120GB worth of disk space on two drives.
Recently, I have noticed that my nightly backups take longer on
Title: RE: [PERFORM] Memory and/or cache issues?
Ok, thank you all again for your help in this matter. Yes, Michael I (the original poster) did say or imply I guess is a better word for it that a combo of training and hands-on is the best way for one to learn PostgreSQL or just about anything
m C. Nasby [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 05, 2006 8:35 PM
To: mcelroy, tim
Cc: 'Michael Stone'; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Memory and/or cache issues?
On Fri, May 05, 2006 at 10:27:10AM -0400, mcelroy, tim wrote:
> Sorry, be
Title: RE: [PERFORM] Memory and/or cache issues?
Thanks for a great explanation Craig, makes more sense now.
Tim
-Original Message-
From: Craig A. James [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 05, 2006 10:51 AM
To: mcelroy, tim
Cc: pgsql-performance
0:41 AM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Memory and/or cache issues?
On Fri, May 05, 2006 at 10:27:10AM -0400, mcelroy, tim wrote:
>Sorry, been up all night and maybe provided too much information or not the
>right information and only confused folks, tire
-Original
Message-
From: Dave Dutcher
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 10:32
AM
To: 'mcelroy, tim'
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Memory
and/or cache issues?
For a standard config
most of the memory used by Postgres is
tgresql.org
Subject: Re: [PERFORM] Memory and/or cache issues?
On Fri, May 05, 2006 at 09:57:58AM -0400, mcelroy, tim wrote:
>Are you saying the kernel's disc cache may be getting whacked? No, I
>understand that PG should use as much memory as it can and the system as
>well
this ran the mem in use jumped up 1G and it hasn't gone down? Once the PG process has finished its task shouldn't it release the memory it used?
Thanks,
Tim
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 05, 2006 9:44 AM
To: mcelroy,
TED]]
Sent: Friday, May 05, 2006 9:25 AM
To: mcelroy, tim
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Memory and/or cache issues?
"mcelroy, tim" <[EMAIL PROTECTED]> writes:
> pg_dump: ERROR: invalid memory alloc request size 184467440737095516
Title: Memory and/or cache issues?
Good morning,
First the stats: I'm using PostgreSQL 8.0.1 (I know I should upgrade, cannot due to vendor app. restrictions...), RedHat 9 on a SUN V40Z with 8GB of memory. I'm using the "out-of-the-box" settings in postgresql.conf. I've been testing vario
ong. If so, we should be upgrading soon and it won't be an issue.
Thanks,
Tim
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 14, 2006 4:17 PM
To: mcelroy, tim
Cc: 'Tom Lane'; pgsql-performance@postgresql.org
Subject:
Title: RE: [PERFORM] Vacuum template databases, Urgent: Production problem
If one adds the '-a' arg to vacuumdb wouldn't that vacuum all databases including template1?
Tim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Tom Lane
Sent: Tues
PM
To: mcelroy, tim
Cc: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] PG Statistics
Tim,
When I have done ODBC load tests with stats_block_level enabled on (20
mins. per test), I've seen about 3-4% performance hit. Your mileage may
vary.
Steve Poe
On Mon,
19 PM
To: mcelroy, tim
Cc: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] PG Statistics
On Mon, Mar 13, 2006 at 06:49:39PM -0500, mcelroy, tim wrote:
> Does anyone know how much of a performance hit turning stats_block_level and
> stats_row_level on will in
Title: PG Statistics
Good evening,
Does anyone know how much of a performance hit turning stats_block_level and stats_row_level on will incur? Do both need to be on to gather cache related statistics? I know the annotated_conf_80 document states to only turn them on for debug but if they'
; (1 row)
Thank you,
Tim
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 08, 2006 10:24 PM
To: mcelroy, tim
Cc: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] pg_reset_stats + cache I/O %
On Wed, Mar
to test any cache tuning changes I may make.
Tim
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 08, 2006 1:28 PM
To: mcelroy, tim
Cc: 'Tom Lane'; 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] pg
Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 07, 2006 2:37 PM
To: mcelroy, tim
Cc: 'pgsql-performance@postgresql.org'
Subject: Re: [PERFORM] pg_reset_stats + cache I/O %
"mcelroy, tim" <[EMAIL PROTECTED]> wri
Title: pg_reset_stats + cache I/O %
Good afternoon,
Relatively new to PostgreSQL and have been assigned the task of capturing cache I/O % hits. I figured out (thanks to other posts) how to turn on the capture and what stats to (kind of) capture. I did find a view in the archives as shown be
21 matches
Mail list logo
