Re: SELECT INTO large FKyed table is slow

From: "Pierre C" <lists(at)peufeu(dot)com>
To: "Mario Splivalo" <mario(dot)splivalo(at)megafon(dot)hr>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT INTO large FKyed table is slow
Date: 2010-11-28 21:50:42
Message-ID: op.vmwhmsepeorkce@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message aaliya zarrin 2010-11-29 04:39:31 Hi- Sleeptime reduction
Previous Message Mario Splivalo 2010-11-28 19:08:22 Re: SELECT INTO large FKyed table is slow