The kernel on our Linux system doesn't appear to have these two settings
according to the list provided by sysctl -a. Please pardon my ignorance, but
should I add them?
We have Postgresql 9.0 on Linux 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT
2009 x86_64 x86_64 x86_64 GNU/Linux
Thanks,
Mid
- Original Message -
From: Tom Lane
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Friday, August 03, 2012 11:26 PM
Subject: Re: [PERFORM] slow query, different plans
"Midge Brown" writes:
> I'm having a problem with a query on our prod
thing there ...
Greg Williamson
--
From: Midge Brown
To: pgsql-performance@postgresql.org
Sent: Friday, August 3, 2012 5:38 PM
Subject: [PERFORM] slow query, different plans
I'm having a problem wi
I'm having a problem with a query on our production server, but not on a laptop
running a similar postgres version with a recent backup copy of the same table.
I tried reindexing the table on the production server, but it didn't make any
difference. Other queries on the same table are plenty fas
make sense? Any comments or suggestions are welcome.
Thanks,
Midge
- Original Message -
From: Josh Berkus
To: pgsql-performance@postgresql.org
Sent: Wednesday, June 20, 2012 5:28 PM
Subject: Re: [PERFORM] moving tables
On 6/20/12 3:27 PM, Midge Brown wrote:
> I need
I need to move a postgres 9.0 database -- with tables, indexes, and wals
associated with 16 tablespaces on 12 logical drives -- to an existing raid 10
drive in another volume on the same server. Once I get the data off the initial
12 drives they will be reconfigured, at which point I'll need to
input for upgrade
On 08/18/2011 05:55 PM, Midge Brown wrote:
DB1 is 10GB and consists of multiple tables that I've spread out so that
the 3 most used have their data and indexes on 6 separate RAID1 drives, the 3
next busiest have data & index on 3 drives, and the remaining table
Thank you. I'll set work_mem back to 16MB and see what happens from there.
-Midge
- Original Message -
From: Scott Marlowe
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Saturday, August 20, 2011 9:01 PM
Subject: Re: [PERFORM] settings input for upgrade
Thank you!
- Original Message -
From: Scott Marlowe
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Saturday, August 20, 2011 9:01 PM
Subject: Re: [PERFORM] settings input for upgrade
On Thu, Aug 18, 2011 at 3:55 PM, Midge Brown wrote:
> Here are
did
make a positive change in write performance. I was including that information
only in an attempt to provide as much detail as possible.
- Midge
- Original Message -
From: Robert Klemme
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Saturday, August 20, 2011 2
I'm in the process of upgrading from postgres 7.4.8 to 9.0.4 and wanted to run
my decisions past some folks who can give me some input on whether my decisions
make sense or not.
It's basically a LAPP configuration and on a busy day we probably get in the
neighborhood of a million hits.
Serve
11 matches
Mail list logo