Re: SLOOOOOOOW - Mailing list pgsql-general

From Ian Harding
Subject Re: SLOOOOOOOW
Date
Msg-id 7256023005090614513530f51a@mail.gmail.com
Whole thread Raw
In response to SLOOOOOOOW  (Jürgen Rose <anykey@gmx.de>)
List pgsql-general
On 9/6/05, Jürgen Rose <anykey@gmx.de> wrote:

> I did some serious stuff with SQLServer and Interbase, and I had
> **never** those performance problems.
>

On a laptop?  Under VMWare?

I have used MSSQL Server too, and find PostgreSQL to compare favorably
in most cases.  You may have found a case where it does not.  I have
found PostgreSQL to work fine out of the box in most cases, with the
main 'obscure knob' that needs to be twiddled being sort_mem (or
work_mem for 8.0 and up.)

If you give specifics of your database structure and migration
functions I am sure someone on the list will be able to help you get
reasonable performance.

> enough of ranting, but I'm totally frustrated

It will work out.

- Ian

> with best regards
> Jürgen
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

pgsql-general by date:

Previous
From: Kevin Barnard
Date:
Subject: Help with row locks on 7.4 to 8.0 migration
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Basic locking question