Home > mailing lists

Re: create index right after create table not working? - Mailing list pgsql-sql

From	Manfred Koizar
Subject	Re: create index right after create table not working?
Date	March 17, 2003 06:09:43
Msg-id	c00b7vc85h4pil73bqmvnr8gntbv004kvh@4ax.com Whole thread Raw
In response to	create index right after create table not working? (Joost Witteveen <joostje@komputilo.org>)
List	pgsql-sql

Tree view

On Sun, 16 Mar 2003 00:53:32 +0100, Joost Witteveen
<joostje@komputilo.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.

ServusManfred

pgsql-sql by date:

From: "Objectz"
Date: 17 March 2003, 06:01:37
Subject: String aggregate function

From: Abdul Wahab Dahalan
Date: 17 March 2003, 06:30:19
Subject: How to compare dates?

Re: create index right after create table not working? - Mailing list pgsql-sql

Previous

Next