Re: [SQL] Slow self-join on a 100 million record table

whole? How many rows does each individual select return and how many for the final statement? -- Andrew J. Kelly SQL Server MVP "Mark Davies" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a database containing 100 milli

[SQL] selecting from integer[]

select * from pg_user where usesysid=(select grolist[1] from pg_group where groname='mygroup'); select * from pg_user where usesysid=(select grolist[2] from pg_group where groname='mygroup'); select * from pg_user where usesysid=(select grolist[3] from pg_group where groname='mygroup'); Can t

[SQL] cron job INSERT appears to bail.

t is limiting? I know this is probably a systems issue, rather than a PostgreSQL issue per se, but I am completely stumped. And this is all a little embarassing! Linux Mandrake 7.0, Intel platform, postgres 6.5.2 -- # Allan Kellyhttp://www.plotsearch.co.uk