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
-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
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
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