Postgres Pro
Downloads
Home   >   mailing lists

Re: Query runs forever after upgrading to 9.3 - Mailing list pgsql-general

From bricklen
Subject Re: Query runs forever after upgrading to 9.3
Date
Msg-id CAGrpgQ9Q1QoCqQ8_4wgc6CrxGuWGVcUyC5dQT1MNk0vGNjFvsw@mail.gmail.com
Whole thread Raw
In response to Re: Query runs forever after upgrading to 9.3  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: Query runs forever after upgrading to 9.3  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view

On Mon, Sep 23, 2013 at 8:06 AM, Andrus <kobruleht2@hot.ee> wrote:

>Could you please post EXPLAIN for that query?

Could you also post the results of the following query?

SELECT name, current_setting(name), source
FROM pg_settings
WHERE source NOT IN ('default', 'override');

Also, what is the total memory in the server?

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Query runs forever after upgrading to 9.3
Next
From: "Andrus"
Date:
Subject: Re: Query runs forever after upgrading to 9.3