Scott Marlowe wrote:
> On Sat, Jan 24, 2009 at 3:57 AM, Thomas Finneid <tfinneid(at)fcon(dot)no> wrote:
> Is this table constantly growing, or is it at a stable plateu? I'd
> assume a constantly growing table, or one with bloat problems would
> get slower over time. About how many rows does this table have?
The table is constantly growing, by 20000 rows per second.
I did a test with an index for all id fields, and the insert time is
constant for every insert up to 1.2 billion rows. Then I stopped the
test because I didn't have more disk space allocated.
In response to
pgsql-performance by date
|Next:||From: Thomas Finneid||Date: 2009-01-25 08:14:45|
|Subject: Re: strange index performance?|
|Previous:||From: Greg Smith||Date: 2009-01-25 07:26:44|
|Subject: Re: SSD performance|