Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying 19million records very slowly - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Querying 19million records very slowly
Date
Msg-id 20050623153112.GS7839@tobias
Whole thread Raw
In response to Re: Querying 19million records very slowly  (Kjell Tore Fossbakk <kjelltore@gmail.com>)
List pgsql-performance
Tree view 
>  I'm running FreeBSD 4.11, and im editing the file in
> /usr/local/etc/postgresql.conf, but it doesnt help.

On my system the 'live' config file resides in
/var/lib/postgresql/data/postgresql.conf - maybe you have them in
/usr/local/var/lib ...

--
Tobias Brox, +86-13521622905
Nordicbet, IT dept

pgsql-performance by date:

Previous
From: Elliott Bennett
Date:
Subject: select distinct on varchar - wild performance differences!
Next
From: Tom Lane
Date:
Subject: Re: select distinct on varchar - wild performance differences!