Re: [BUGS] BUG #2243: Postgresql fails to finish some queries

2006-02-09 Thread Andrew - Supernews
On 2006-02-08, Matej Rizman <[EMAIL PROTECTED]> wrote: > No. > > But the similar problem first appeared on tables that are on > production servers and VACUUMed regularly (in addition to autovacuum). > > The same problem appears if tables are created with SELECT INTO and > with indices created latte

Re: [BUGS] BUG #2243: Postgresql fails to finish some queries

2006-02-09 Thread Matej Rizman
2006/2/8, Bruno Wolff III <[EMAIL PROTECTED]>: > On Tue, Feb 07, 2006 at 02:41:03 +, > Matej Rizman <[EMAIL PROTECTED]> wrote: > > > > Files a_3.txt and b_3.txt contain 3 numbers each. > > > > The last query (SELECT) is executed on my machine in 125ms. > > > > If I load data from

Re: [BUGS] BUG #2243: Postgresql fails to finish some queries

2006-02-08 Thread Bruno Wolff III
On Tue, Feb 07, 2006 at 02:41:03 +, Matej Rizman <[EMAIL PROTECTED]> wrote: > > Files a_3.txt and b_3.txt contain 3 numbers each. > > The last query (SELECT) is executed on my machine in 125ms. > > If I load data from files a_10.txt and b_10.txt that contain 10 > n