Skip site navigation (1) Skip section navigation (2)

Re: strange index performance?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Thomas Finneid <tfinneid(at)fcon(dot)no>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange index performance?
Date: 2009-01-24 14:57:10
Message-ID: dcc563d10901240657v466a522fi373aa4f3cdf8a9dd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, Jan 24, 2009 at 3:57 AM, Thomas Finneid <tfinneid(at)fcon(dot)no> wrote:
> Hi
>
> I just experienced a performance loss on inserts when redefining my index on
> a table.
>
> I have a database with the following table
>
> table:
>   id1  int
>   id2  int
>   id3  int
>   id4  int
>   val1 float
>   ....
>   tablespace dbspace
>
> the data id distribution is hierarchical and even, well fitting to a btree,
> there is about 20000 rows per insert (actually a jdbc COPY)

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?

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2009-01-24 19:32:58
Subject: Re: strange index performance?
Previous:From: Thomas FinneidDate: 2009-01-24 10:57:21
Subject: strange index performance?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group