[GENERAL] Poor Delete performance

2001-03-11 Thread Bill Huff
res lists and checked the FAQ and I can't find anything that gives any insight into increasing delete performance. Any information whatsoever would be greatly appreciated. -- Bill -- _ / ___/___ | Bill Huff / [EMAIL PROTECTED] / /__ __/ | Voice: (512) 26

Re: [GENERAL] Poor Delete performance

2001-03-12 Thread Bill Huff
constraints > defined on it? > > On Mon, 12 Mar 2001, Bill Huff wrote: > > > I am having some performance issues with deletion. > > > > It appears that in deleting records from a table with a significant > > number or rows ( in this case 1.3 million ) it ta

Re: [GENERAL] Re: Re: LIKE and indexes?

2001-03-15 Thread Bill Huff
broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- _ / ___/___ | Bill Huff / [EMAIL PROTECTED] / /__ __/ | Voice: (512) 263-0770 x 262 / /__/ / | Fax: (512) 263-8921 \___/ /ol

Re: [GENERAL] Postgres SQL Query (Generating Date Groups)

2001-03-16 Thread Bill Huff
this possible under Postgres? What can I do to accomplish this > without writing a separate select for each date period? Thank you in > advance! > > Mont Erickson > [EMAIL PROTECTED] (remove "ns_" to reply) > > ---(end of broadcast)--