Re: Querying 19million records very slowly

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Kjell Tore Fossbakk <kjelltore(at)gmail(dot)com>
Cc: Tobias Brox <tobias(at)nordicbet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Querying 19million records very slowly
Date: 2005-06-23 15:31:12
Message-ID: 20050623153112.GS7839@tobias
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-23 15:34:55 Re: select distinct on varchar - wild performance differences!
Previous Message Elliott Bennett 2005-06-23 15:09:45 select distinct on varchar - wild performance differences!