Hello,
I compiled the snapshot from 16. Oct on Sparc Linux. Make and make
install worked perfectly and I was able to start the postmaster as
described in INSTALL. But:
postgres:~$ ps ax | grep post
8575 ttyp4S 0:00 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
8576 ttyp4
On Fri, 21 Sep 2001, Justin Clift wrote:
> Hi Andreas,
>
> I'm running PostgreSQL 7.1.3 here on a PC with nearly a gig of ram, and
> running Linux Mandrake 8.0
>
> First thing I did was to increase the amount of shared memory and stuff
> which Linux allows things to use :
>
> echo "kernel.shmall
On Thu, 20 Sep 2001, Einar Karttunen asked me for query plans for
both M$ SQL and postgresql:
M$ SQL:
|--Compute Scalar(DEFINE:([Expr1002]=Convert([Expr1005])))
|--Stream Aggregate(GROUP BY:([Hauptdaten_Fall].[MeldeKategorie])
DEFINE:([Expr1005]=Count(*)))
|--Index
Scan(OBJE
On Thu, 20 Sep 2001, Justin Clift wrote:
> Sorry, I haven't seen the history of this thread. One question which
> might be relevant is, have you adjusted the postgresql.conf file from
> the default memory settings to be something better?
I adjusted two parameters:
shared_buffers = 2048
(When I
On Thu, 20 Sep 2001, Herbert Liechti wrote:
> I tried it. See my actions below. The main performance boost is
> reached by creating an index and disabling the sequential scan:
Thanks. I tried this and it helps in dead (see below).
> ---
> crea
On Wed, 19 Sep 2001, Tom Lane wrote:
> No. In the first place, there's no extra sort: the planner is well
> aware that our current GROUP BY implementation produces ordered output.
> In the second place, there's no guarantee that GROUP BY will always
> produce ordered output in the future --- we
On Mon, 10 Sep 2001 [EMAIL PROTECTED] wrote:
> Use explain. Explain tells you the query plan of the optimizer.
>
> explain SELECT .;
Thanks I just found the thread "Index usage question" and tried to make
some profit from it:
explain SELECT Hauptdaten_Fall.MeldeKategorie, Count(Hauptdaten_Fa
Hello,
I have ported a database from MS SQL Server to PostgreSQL. The database has
40 tables and 117 indexes which I defined for the same fields as in MS SQL.
I converted the data using some SQL output from MS SQL server and inserted
it with psql.
Now I started some performance comparisons and
