Re: [PERFORM] Slow plan for MAX/MIN or LIMIT 1?

2013-09-29 Thread didier
Hi On Wed, Sep 25, 2013 at 6:42 PM, Sam Wong wrote: > > > --- > Excuse me, this is the actual query. > > with Q AS ( > select event > from event_log > WHERE log_id>101 and log_id<105 > order by event > ) > SELECT * FROM Q LIMIT 1 > > > > Limit (cost=2521.82..2521.83 rows=1 width=32) (a

Re: [PERFORM] BASH script for collecting analyze-related info

2013-09-29 Thread Craig James
On Sun, Sep 29, 2013 at 2:24 PM, Ken Tanzer wrote: > p.s., This script runs fine on my computer (Ubuntu 13.04), but on a >>> Fedora 11 machine it dies with >>> >>> pg_analyze_info.sh: line 18: unexpected EOF while looking for matching >>> `)' >>> pg_analyze_info.sh: line 57: syntax error: unexp

Re: [PERFORM] BASH script for collecting analyze-related info

2013-09-29 Thread Ken Tanzer
> > p.s., This script runs fine on my computer (Ubuntu 13.04), but on a >> Fedora 11 machine it dies with >> >> pg_analyze_info.sh: line 18: unexpected EOF while looking for matching `)' >> pg_analyze_info.sh: line 57: syntax error: unexpected end of file >> >> If anyone knows why, or encounters

Re: [PERFORM] BASH script for collecting analyze-related info

2013-09-29 Thread Craig James
On Sun, Sep 29, 2013 at 2:09 AM, Ken Tanzer wrote: > I just sent off to this list for query help, and found the process of > gathering all the requested info somewhat tedious. So I created a little > BASH script to try to pull together as much of this information as > possible. > > The script re

[PERFORM] BASH script for collecting analyze-related info

2013-09-29 Thread Ken Tanzer
I just sent off to this list for query help, and found the process of gathering all the requested info somewhat tedious. So I created a little BASH script to try to pull together as much of this information as possible. The script reads an analyze file, and generates SQL queries to retrieve the f