Re: [JDBC] [PERFORM] is a good practice to create an index on the - Mailing list pgsql-admin

From Christopher Kings-Lynne
Subject Re: [JDBC] [PERFORM] is a good practice to create an index on the
Date
Msg-id 408F6A76.9070908@familyhealth.com.au
Whole thread Raw
In response to Re: [JDBC] [PERFORM] is a good practice to create an index on the  (Edoardo Ceccarelli <eddy@axa.it>)
List pgsql-admin
> do you mean that, declaring an index serial, I'd never have to deal with
> incrementing its primary key? good to know!

Yep. You can use 'DEFAULT' as the value, eg:

INSERT INTO blah (DEFAULT, ...);

> anyway  in this particular situation I don't need such accurate
> behaviour: this table is filled up with a lot of data twice per week and
> it's used only to answer queries.
> I could drop it whenever I want :)

Sure.

Chris


pgsql-admin by date:

Previous
From: Edoardo Ceccarelli
Date:
Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the
Next
From: Bruno Wolff III
Date:
Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the