Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT INTO large FKyed table is slow - Mailing list pgsql-performance

From Pierre C
Subject Re: SELECT INTO large FKyed table is slow
Date
Msg-id op.vmwhmsepeorkce@apollo13
Whole thread Raw
In response to Re: SELECT INTO large FKyed table is slow  (Mario Splivalo <mario.splivalo@megafon.hr>)
Responses Re: SELECT INTO large FKyed table is slow  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-performance
Tree view 
> I pasted DDL at the begining of my post.

Ah, sorry, didn't see it ;)

> The only indexes tables have are the ones created because of PK
> constraints. Table drones has around 100k rows. Table drones_history has
> around 30M rows. I'm not sure what additional info you'd want but I'll
> be more than happy to provide more relevant information.

Can you post the following :

- pg version
- output of VACCUM ANALYZE VERBOSE for your 2 tables

pgsql-performance by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: SELECT INTO large FKyed table is slow
Next
From: aaliya zarrin
Date:
Subject: Hi- Sleeptime reduction