[GENERAL] Querying a Large Partitioned DB

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

[GENERAL] Retain PREPARE or connect trigger

. Or is there another option like PREPARE that persists? Thanks for your help. Justin Funk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Retain PREPARE or CONNECT TRIGGER

. Or is there another option like PREPARE that persists? Thanks for your help. Justin Funk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Partitioned tabled not using indexes for full text search

I have a table that is partitioned on a daily basis. Full text searches used to be respectably fast with large tables (40 million + records) but insert speed would slow down. So I went with a partitioned approach. But now, it doesn't seem like the indexes are being used. Any idea why it would

[GENERAL] Get IP addresses from tsvectors

'n29c3q08020087':1 'kgan...@iastate.edu':4 into IP_ADDRESSES - 65.110.236.113 10.10.94.126 Thanks for the help... Justin Funk -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql