Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Search on very big (partitioned) table - Mailing list pgsql-general

From Collini, ColliniConsulting.it
Subject [GENERAL] Search on very big (partitioned) table
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC730@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: [GENERAL] Search on very big (partitioned) table  (Adam Brusselback <adambrusselback@gmail.com>)
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?

Thank you!
/F
 

pgsql-general by date:

Previous
From: Thomas Güttler
Date:
Subject: Re: [GENERAL] PostgreSQL on eMMC - Corrupt file system
Next
From: Job
Date:
Subject: [GENERAL] Slow queries on very big (and partitioned) table