db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4056) Space is not reclaimed when index
Date Fri, 13 Feb 2009 10:15:59 GMT
Space is not reclaimed when index 

                 Key: DERBY-4056
                 URL: https://issues.apache.org/jira/browse/DERBY-4056
             Project: Derby
          Issue Type: Bug
          Components: Store
    Affects Versions:,
            Reporter: Knut Anders Hatlen

If you try to insert a row which would violate a unique constraint,
the insert is rolled back, but the space is not reclaimed.

This was mentioned in a comment to DERBY-4028 (26/Jan/09):

> Out of curiosity, I tried this code:
>         s.execute("create table d4028(x int unique)");
>         while (true) {
>             try {
>                 s.execute("insert into d4028 values 1");
>             } catch (SQLException e) {
>                 System.out.println(e);
>             }
>         }
> Even though it only inserts one row, the disk footprint just keeps
> growing. It's the disk footprint of the table that's growing, though,
> not the index, so it looks like the free space in the index is reused.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message