Re: [GENERAL] Querying a Large Partitioned DB

2009-04-12 Thread Simon Riggs
On Fri, 2009-04-10 at 09:15 -0500, Justin Funk wrote: > I need to be able to do full text searches on the message field, and > of course, it needs to be reasonably fast. > > The table is partitioned daily and has this structure: > My typical query looks like this: > SELECT * FROM SystemEvents W

Re: [GENERAL] Querying a Large Partitioned DB

2009-04-10 Thread A.M.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Apr 10, 2009, at 10:15 AM, Justin Funk wrote: Team Amazing, I am building a massive database for storing the syslogs of a room of servers. The database gets about 25 million entries a day, and need to keep them for 180 days. So the total siz

Re: [GENERAL] Querying a Large Partitioned DB

2009-04-10 Thread Tom Lane
Justin Funk writes: > Can you give me any tips and suggestions about how to speed this up? Use fewer partitions --- 180 is a lot. Maybe weekly partitioning would be about right. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Querying a Large Partitioned DB

2009-04-10 Thread Justin Funk
Team Amazing, I am building a massive database for storing the syslogs of a room of servers. The database gets about 25 million entries a day, and need to keep them for 180 days. So the total size of the database will be about 4.5 billion records. I need to be able to do full text searches on the