Re: [PERFORM] PostgreSQL performance question. [OT]

2005-12-17 Thread Steinar H. Gunderson
On Sun, Dec 18, 2005 at 02:11:16AM +, Harry Jackson wrote: > The one thing that may be skewing these results is that this was > compiled and installed from source with > > ./configure CFLAGS='-O2' --with-openssl --enable-thread-safety > > I am not sure what the default Debian binary for 7.4.7

Re: [PERFORM] PostgreSQL performance question.

2005-12-17 Thread Harry Jackson
On 12/15/05, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > PostgreSQL 8.1.1 should give you greater performance... Indeed it has. I am seeing a 25% increase in one particular select statement. This increases to 32% with set enable_bitmapscan to off; I also ran a test script full of commo

Re: [PERFORM] PostgreSQL performance question.

2005-12-14 Thread Gavin Sherry
On Thu, 15 Dec 2005, Harry Jackson wrote: > Hi all, > I have been using PostgreSQL (currently 7.4.7) for several years now and > am very happy with it but I currently run a website that has had a > little bit of a boost and I am starting to see some performance problems > (Not necessarily Postgre

Re: [PERFORM] PostgreSQL performance question.

2005-12-14 Thread Christopher Kings-Lynne
I have been using PostgreSQL (currently 7.4.7) for several years now and am very happy with it but I currently run a website that has had a little bit of a boost and I am starting to see some performance problems (Not necessarily PostgreSQL). PostgreSQL 8.1.1 should give you greater performanc

[PERFORM] PostgreSQL performance question.

2005-12-14 Thread Harry Jackson
Hi all, I have been using PostgreSQL (currently 7.4.7) for several years now and am very happy with it but I currently run a website that has had a little bit of a boost and I am starting to see some performance problems (Not necessarily PostgreSQL). The original website server ran on a singl