Re: [JDBC] [PERFORM] is a good practice to create an index on the

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [JDBC] [PERFORM] is a good practice to create an index on the
Дата
Msg-id 408F6A76.9070908@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [JDBC] [PERFORM] is a good practice to create an index on the  (Edoardo Ceccarelli <eddy@axa.it>)
Список 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 по дате отправления:

Предыдущее
От: Edoardo Ceccarelli
Дата:
Сообщение: Re: [JDBC] [PERFORM] is a good practice to create an index on the
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: [JDBC] [PERFORM] is a good practice to create an index on the