Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Slow queries on very big (and partitioned) table - Mailing list pgsql-general

From Job
Subject [GENERAL] Slow queries on very big (and partitioned) table
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAEE@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: [GENERAL] Slow queries on very big (and partitioned) table  (Jaime Soler <jaime.soler@gmail.com>)
Re: [GENERAL] Slow queries on very big (and partitioned) table  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Collini, ColliniConsulting.it"
Date:
Subject: [GENERAL] Search on very big (partitioned) table
Next
From: Jaime Soler
Date:
Subject: Re: [GENERAL] Slow queries on very big (and partitioned) table