SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 11:29 AM
| ||||
| ||||
 Re: 4 way JOIN using aliases > -----Original Message----- > From: Keith Worthington [mailto:KeithW@narrowpathinc.com] > Sent: Monday, April 11, 2005 7:44 PM > To: Neil Conway > Cc: PostgreSQL Perform > Subject: Re: [PERFORM] 4 way JOIN using aliases > > Neil Conway wrote: > > Keith Worthington wrote: > > > >> -> Seq Scan on tbl_current > (cost=0.00..1775.57 rows=76457 > >> width=31) (actual time=22.870..25.024 rows=605 loops=1) > > > > > > This rowcount is way off -- have you run ANALYZE recently? > > [...] > > I run vacuumdb with the analyze option every morning via a > cron job. In my ignorance I do not know if that is the same > thing. Pass it an --analyze option if you aren't already. __ David B. Held Software Engineer/Array Services Group 200 14th Ave. East, Sartell, MN 56377 320.534.3637 320.253.7800 800.752.8129 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org      |
|
04-18-2008, 11:29 AM
| ||||
| ||||
| Re: 4 way JOIN using aliases On Tue, 12 Apr 2005 08:41:55 -0500, Dave Held wrote > > -----Original Message----- > > From: Keith Worthington [mailto:KeithW@narrowpathinc.com] > > Sent: Monday, April 11, 2005 7:44 PM > > To: Neil Conway > > Cc: PostgreSQL Perform > > Subject: Re: [PERFORM] 4 way JOIN using aliases > > > > Neil Conway wrote: > > > Keith Worthington wrote: > > > > > >> -> Seq Scan on tbl_current > > (cost=0.00..1775.57 rows=76457 > > >> width=31) (actual time=22.870..25.024 rows=605 loops=1) > > > > > > > > > This rowcount is way off -- have you run ANALYZE recently? > > > [...] > > > > I run vacuumdb with the analyze option every morning via a > > cron job. In my ignorance I do not know if that is the same > > thing. > > Pass it an --analyze option if you aren't already. > > __ > David B. Held > Here is the command I have in the cron file. vacuumdb --full --analyze --verbose --username dbuser --dbname ${IPA_DB} >> ${IPA_LOG_DIR}/ipavcmdb.log 2>&1 If this performs the analyze as I thought it should I do not know why the row count is so badly off. Kind Regards, Keith ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq |
Linear Mode
