Re: create index right after create table not working?

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Joost Witteveen <joostje(at)komputilo(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: create index right after create table not working?
Date: 2003-03-17 08:08:42
Message-ID: c00b7vc85h4pil73bqmvnr8gntbv004kvh@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, 16 Mar 2003 00:53:32 +0100, Joost Witteveen
<joostje(at)komputilo(dot)org> wrote:
>Can CREATE index commands be issued right after the CREATE TABLE?

Yes. And the index will be used if you do ANALYSE yourtable; or even
better VACUUM ANALYSE yourtable; after you have initially loaded your
table and before you start querying it.

Servus
Manfred

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Abdul Wahab Dahalan 2003-03-17 08:29:54 How to compare dates?
Previous Message Objectz 2003-03-17 08:01:10 String aggregate function