Re: [BUGS] Bug #833: prep_buildtree and solaris ln
[EMAIL PROTECTED] (Bruce Momjian) writes: > 'ln -fs' doesn't do the same thing as 'ln -s -f' on Solaris? Are you > sure? This is the first we are hearing this. > /bin/ln works as expected, but /usr/ucb/ln requires the latter form. (We BSD fanatics tend to have /usr/ucb before /bin in path to get the 'correct' behaviour from commands like df and ps...) _ Mats Lofkvist [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[BUGS] Bug #834: not usage index in subquerys o inner joins
Gabriel Monsalvo ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description not usage index in subquerys o inner joins Long Description PostgreSQL makes sequencial scans when uses subqueries or inner joins like: select * from ctacte where numoble in (select numoble from obligacion where numoble='251368995'); or: select c.* from ctacte c inner join obligacion o on (c.numoble=0.numoble and o.objeto='0007314') we have ten million of records in our tables and you can imagine how much time that takes long Any solution? or idea? Sample Code No file was uploaded with this report ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [BUGS] Bug #833: prep_buildtree and solaris ln
I would like to see someone else have this problem before making such an unusual change. --- Mats Lofkvist wrote: > [EMAIL PROTECTED] (Bruce Momjian) writes: > > > 'ln -fs' doesn't do the same thing as 'ln -s -f' on Solaris? Are you > > sure? This is the first we are hearing this. > > > > /bin/ln works as expected, but /usr/ucb/ln requires the latter form. > > (We BSD fanatics tend to have /usr/ucb before /bin in path to > get the 'correct' behaviour from commands like df and ps...) > > _ > Mats Lofkvist > [EMAIL PROTECTED] > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
