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
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
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
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
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