Re: [PERFORM] different query plan for same select

2003-07-23 Thread Jörg Schulz
> > I'm not very familar with the output of the explain command but can you > > tell me why I get two different query plans? > > Judging from the suspiciously round numbers in the cost estimates, > you've never done a VACUUM ANALYZE on any of these tables. Try that and > then see what plans you ge

Re: [PERFORM] different query plan for same select

2003-07-23 Thread Tom Lane
=?iso-8859-1?q?J=F6rg=20Schulz?= <[EMAIL PROTECTED]> writes: > I'm not very familar with the output of the explain command but can you > tell me why I get two different query plans? Judging from the suspiciously round numbers in the cost estimates, you've never done a VACUUM ANALYZE on any of thes

[PERFORM] different query plan for same select

2003-07-23 Thread Jörg Schulz
I have these two tables with the same data on two different machines (SuSE 8.2 and Gentoo both with 7.3.2): schulz=> \d rechnung Table "jschulz.rechnung" Column | Type | Modifiers +--+--- system | smallint | not null jahr |