Thread: SPEED UP.

I would like to know is there is a specific way to speed up my query to
postgres.

I have a DB-MACHINE that I use just and only for postgres witch runs
linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs.

I run vacuum every hour, but there is something else I can do (compile
postgres in a special way ) to get the best from postgres ??


Thanks in advance

Alex

Lets see your queries you're running and their plan, I'd bet there are ways
to speed them up (that's always been the case with mine!).. fields


- Mitch

"The only real failure is quitting."


----- Original Message -----
From: Alessandro Rossi <alex@radiostudiodelta.it>
To: <pgsql-sql@postgresql.org>
Sent: Friday, June 02, 2000 2:49 AM
Subject: [SQL] SPEED UP.


>
>
> I would like to know is there is a specific way to speed up my query to
> postgres.
>
> I have a DB-MACHINE that I use just and only for postgres witch runs
> linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs.
>
> I run vacuum every hour, but there is something else I can do (compile
> postgres in a special way ) to get the best from postgres ??
>
>
> Thanks in advance
>
> Alex
>
>
>

> 
> 
> I would like to know is there is a specific way to speed up my query to
> postgres.

Please post the exact command line arguments you are giving when you start
the postmaster daemon process.

Cordially

Patrick Giagnocavo
a222@redrose.net