Re: [PERFORM] Optimizing Bitmap Heap Scan.

2009-12-08 Thread Lennin Caro
From: niraj patel Subject: Re: [PERFORM] Optimizing Bitmap Heap Scan. To: "Grzegorz Jaśkiewicz" Cc: pgsql-performance@postgresql.org Date: Tuesday, December 8, 2009, 1:50 PM Hi gryzman, I have run vacuum full analyze on the cmrules tables. The version of pstgres is 8.2.13. How should I change

Re: [PERFORM] statistical table

2009-09-17 Thread Lennin Caro
usage.         - Disk space.         - Memory allocation. thank you. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance in GNU/linux like debian you can use the sysstat package Ing. Lennin

Re: [PERFORM] bizarre query performance question

2008-10-01 Thread Lennin Caro
--- On Wed, 10/1/08, H. William Connors II <[EMAIL PROTECTED]> wrote: > From: H. William Connors II <[EMAIL PROTECTED]> > Subject: [PERFORM] bizarre query performance question > To: pgsql-performance@postgresql.org > Date: Wednesday, October 1, 2008, 8:34 PM > I have two fairly simple tables as

Re: [PERFORM] long transaction

2008-07-18 Thread Lennin Caro
have you use VACUMM? --- On Fri, 7/18/08, Sabin Coanda <[EMAIL PROTECTED]> wrote: > From: Sabin Coanda <[EMAIL PROTECTED]> > Subject: [PERFORM] long transaction > To: pgsql-performance@postgresql.org > Date: Friday, July 18, 2008, 3:34 PM > Hi there, > > I have a script which includes 3 call