Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group