On 9/4/15 6:59 AM, Tomas Vondra wrote:
Finally, whatever causes the database to wait also causes the
Windows instance to slow down. But restarting Postgresql fixes
this as well.
That's a bit strange, I guess. If you're not observing light CPU and I/O
usage, then the instance should not be slow,
Hi,
On 08/27/2015 07:21 PM, Jean Cavallo wrote:
Hi,
I am currently working on a data migration for a client.
The general plan is :
- Read data from a postgresql database
- Convert them to the new application
- Insert in another database (same postgresql instance).
The source database
ormance-ow...@postgresql.org] *On Behalf Of *Jean Cavallo
> *Sent:* Thursday, August 27, 2015 1:21 PM
> *To:* pgsql-performance@postgresql.org
> *Subject:* [PERFORM] Server slowing down over time
>
>
>
> Hi,
>
>
>
> I am currently working on a data migration for a cl
From: pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] On Behalf Of Jean Cavallo
Sent: Thursday, August 27, 2015 1:21 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] Server slowing down over time
Hi,
I am currently working on a data migration
Hi,
I am currently working on a data migration for a client.
The general plan is :
- Read data from a postgresql database
- Convert them to the new application
- Insert in another database (same postgresql instance).
The source database is rather big (~40GB, wo indexes), and the
conversion
