I have some tables which have an extremely high amount of update
activity on them. I have changed autovacuum parameters (cost delay and
limit), and whereas before they would never be vacuumed and bloat they
are running fine.
However, as the platform scales, I am afraid I will reach the same
situa
On Wed, Jan 13, 2010 at 5:51 PM, Benjamin Krajmalnik wrote:
> I have some tables which have an extremely high amount of update activity on
> them. I have changed autovacuum parameters (cost delay and limit), and
> whereas before they would never be vacuumed and bloat they are running fine.
>
> Ho
Yes, I will be using table inheritance and inheriting the current table where
the data resides.
I was wondering if it would be "kosher" to perform the insert on itself, but I
guess since the rules engine takes over there should not be a problem.
The tables are not huge per se (a little over 50K r
On Wed, Jan 13, 2010 at 6:11 PM, Benjamin Krajmalnik wrote:
> Yes, I will be using table inheritance and inheriting the current table where
> the data resides.
> I was wondering if it would be "kosher" to perform the insert on itself, but
> I guess since the rules engine takes over there should
Scott Marlowe wrote:
On Wed, Jan 13, 2010 at 6:11 PM, Benjamin Krajmalnik wrote:
Yes, I will be using table inheritance and inheriting the current table where
the data resides.
I was wondering if it would be "kosher" to perform the insert on itself, but I
guess since the rules engine tak
On Wed, Jan 13, 2010 at 7:30 PM, Radhika Sambamurti wrote:
>
> Hi,
> I am currently looking into partitioning a table of which 90% of the lookups
> are for the prior week. It has about 9 million rows and selects are a bit
> slow, since the table is joined to two other tables. I am planning on
N K wrote:
By default, all connections to DB are restricted by only local ones. I
use the only superuser with non-standard name and very simple password
- "one" or "two", for example. Connection to DB is established over
SSH. Is it safe such technique?
That depends on what you're using the dat
