On Mon, Sep 3, 2012 at 4:22 AM, John Nash
wrote:
> Hi,
>
> We can try installing version 8.4.9, but when downloading the
> software, we installed the binaries and files given in postgresql web
> page named as version 9.1.3. This is the tar file downloaded:
>
> postgresql-9.1.3.tar
>
> Containing t
Hi,
We can try installing version 8.4.9, but when downloading the
software, we installed the binaries and files given in postgresql web
page named as version 9.1.3. This is the tar file downloaded:
postgresql-9.1.3.tar
Containing the following when un-tar-ed:
[postgsql@localhost postgresql-9.1.
On 03/09/2012 13:03, Stefan Keller wrote:
> Hi,
>
> I'm having performance issues with a simple table containing 'Nodes'
> (points) from OpenStreetMap:
>
> CREATE TABLE nodes (
> id bigint PRIMARY KEY,
> user_name text NOT NULL,
> tstamp timestamp without time zone NOT NULL,
>
Hi,
I'm having performance issues with a simple table containing 'Nodes'
(points) from OpenStreetMap:
CREATE TABLE nodes (
id bigint PRIMARY KEY,
user_name text NOT NULL,
tstamp timestamp without time zone NOT NULL,
geom GEOMETRY(POINT, 4326)
);
CREATE INDEX idx_node
Hi,
>
>
> Yeah. well, hm. Is the function returning a whole bunch of data?
> Also, try confirming the slow runtime from the server's point of view;
> log_min_duration_statement is a good setting for that.
>
I did try those options. In the end, removing an order by (it was not
necessary) from
