Re: [PERFORM] Two Necessary Kernel Tweaks for Linux Systems

2013-01-08 Thread Midge Brown
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

Re: [PERFORM] slow query, different plans

2012-08-06 Thread Midge Brown
- 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

Re: [PERFORM] slow query, different plans

2012-08-06 Thread Midge Brown
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

[PERFORM] slow query, different plans

2012-08-03 Thread Midge Brown
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

Re: [PERFORM] moving tables

2012-07-11 Thread Midge Brown
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

[PERFORM] moving tables

2012-06-20 Thread Midge Brown
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

Re: [PERFORM] settings input for upgrade

2011-08-22 Thread Midge Brown
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

Re: [PERFORM] settings input for upgrade

2011-08-22 Thread Midge Brown
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

Re: [PERFORM] settings input for upgrade

2011-08-20 Thread Midge Brown
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

Re: [PERFORM] settings input for upgrade

2011-08-20 Thread Midge Brown
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

[PERFORM] settings input for upgrade

2011-08-18 Thread Midge Brown
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