Slow queries on very big (and partitioned) table

From: Job <Job(at)colliniconsulting(dot)it>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Slow queries on very big (and partitioned) table
Date: 2017-02-20 12:33:26
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAEE@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hu guys,

we have a test machine with Postgresql 9.6.1 an about 800.000.000 record in a table.
Table is partitioned by day, with indexes on partitioned table.

Also a simple query (for example i want to search log occurred in a specific day), is immediate in tha partitioned table (table_2017_02_15) but *extremely* slow in global table.

Where am i wrong?
Shall i create global index?

Thank you!
/F

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Soler 2017-02-20 12:38:52 Re: Slow queries on very big (and partitioned) table
Previous Message Collini, ColliniConsulting.it 2017-02-20 12:31:57 Search on very big (partitioned) table