Re: [PERFORM] query plan, index scan cost

2008-08-13 Thread Decibel!
On Jul 18, 2008, at 5:28 AM, Stefan Zweig wrote: CREATE TABLE nw_tla_2008_4_deu ( "ID" bigint NOT NULL, "NET2CLASS" smallint, "FOW" smallint, CONSTRAINT nw_tla_2008_4_deu_pkey PRIMARY KEY ("ID"), ) WITHOUT OIDS; You might want to give up on the double-quotes... you'll have to use them everywh

[PERFORM] query plan, index scan cost

2008-07-18 Thread Stefan Zweig
hi list, i have a problem with time consuming query. first of all my table structure: CREATE TABLE nw_tla_2008_4_deu ( "ID" bigint NOT NULL, "NET2CLASS" smallint, "FOW" smallint, CONSTRAINT nw_tla_2008_4_deu_pkey PRIMARY KEY ("ID"), ) WITHOUT OIDS; CREATE INDEX nw_tla_2008_4_deu_fow_idx ON nw_t