Re: SELECT INTO large FKyed table is slow

Поиск
Список
Период
Сортировка
От Pierre C
Тема Re: SELECT INTO large FKyed table is slow
Дата
Msg-id op.vmwhmsepeorkce@apollo13
обсуждение исходный текст
Ответ на Re: SELECT INTO large FKyed table is slow  (Mario Splivalo <mario.splivalo@megafon.hr>)
Ответы Re: SELECT INTO large FKyed table is slow  (Mario Splivalo <mario.splivalo@megafon.hr>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: SELECT INTO large FKyed table is slow
Следующее
От: aaliya zarrin
Дата:
Сообщение: Hi- Sleeptime reduction