Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9NDa0P41389 for ; Tue, 23 Oct 2001 09:36:00 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f9NDSsI47780 for pgsql-sql@postgresql.org; Tue, 23 Oct 2001 09:28:54 -0400 (EDT) (envelope-from news) X-Newsgroups: comp.databases.postgresql.sql From: marc@oscar.eng.cv.net (Marc Spitzer) Subject: Re: Index of a table is not used (in any case) References: Message-Id: User-Agent: slrn/0.9.7.0 (FreeBSD) Lines: 43 Date: Tue, 23 Oct 2001 13:28:47 GMT Organization: Optimum Online To: pgsql-sql@postgresql.org X-Archive-Number: 200110/325 X-Sequence-Number: 5278 In article , Josh Berkus wrote: > Reinier, > > For future notice, [SQL] is the correct list for this kind of inquiry. > Please do not post it to [HACKERS]. And please don't cross-post ... it > results in a lot of needless duplication of effort. > >> I have defined a table and the necessary indices. > >> Is the order of index creation relevant? I.e., should I create the >> indices before inserting >> entries or the other way around? > > Ummm ... not to be obvious, or anything, but did you VACCUUM ANALYZE > after populating your table? > > There's also some special steps to take if you are regularly deleting > large numbers of records. Could you tell me what those steps are or where to find them? I have a db that I delete about 1 million records a day from in a batch job. The only special thing I do is every few days I reindex the table involved to reclame the space burned by the indexes not reclaiming space on deletion of rows. What other good and useful things could I do? Thanks marc > > -Josh > > ______AGLIO DATABASE SOLUTIONS___________________________ > Josh Berkus > Complete information technology josh@agliodbs.com > and data management solutions (415) 565-7293 > for law firms, small businesses fax 621-2533 > and non-profit organizations. San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster