Re: [PERFORM] Seq scan on 10million record table.. why?

or partitioning. Sorry for not being able to help you more in this case. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it -- Sent via pgsql-performance mailing list (pgsql-performance

[PERFORM] Different location or different instance

in the mailing list archive - please forgive me). Ciao, -Gabriele -- Gabriele Bartolini: Web Programmer, ht://Dig IWA/HWG Member, ht://Check maintainer Current Location: Prato, Toscana, Italia [EMAIL PROTECTED] | http://www.prato.linux.it/~gbartolini | ICQ#129221447 Leave every hope, ye who enter

[PERFORM] Question regarding the file system

anything from it or should I stick with 2.4.x? Thank you very much, -Gabriele -- Gabriele Bartolini: Web Programmer, ht://Dig IWA/HWG Member, ht://Check maintainer Current Location: Prato, Toscana, Italia [EMAIL PROTECTED] | http://www.prato.linux.it/~gbartolini | ICQ#129221447 Leave every hope, ye

Re: [PERFORM] Normal case or bad query plan?

Hi Kris, I believe the problem is that pg's lack of cross-column statistics is producing the poor number of rows estimate. The number of rows mataching I got your point now. I had not understood it last night but it makes really sense. which is roughtly 10% of the table. I imagine the query

[PERFORM] Normal case or bad query plan?

or comment to do (that would be extremely appreciated)? Is the CLUSTER I created worthwhile or not? Thank you, -Gabriele -- Gabriele Bartolini: Web Programmer, ht://Dig IWA/HWG Member, ht://Check maintainer Current Location: Prato, Toscana, Italia [EMAIL PROTECTED] | http://www.prato.linux.it

Re: [PERFORM] Normal case or bad query plan?

Hi Tom, thanks for your interest. At 23.33 11/10/2004, Tom Lane wrote: Gabriele Bartolini [EMAIL PROTECTED] writes: QUERY PLAN

Re: [PERFORM] Data warehousing requirements

. Your contribution has been really important to me. Ciao, -Gabriele Let us not speak of them; but look, and pass on. P.S.: Dante rules ... :-) -- Gabriele Bartolini: Web Programmer, ht://Dig IWA/HWG Member, ht://Check maintainer Current Location: Prato, Toscana, Italia [EMAIL PROTECTED] | http

[PERFORM] Data warehousing requirements

this in mind, what hardware architecture should I look for? How many hard disks do I need, what kind and what RAID solution do you suggest me to adopt (5 or 10 - I think)? Thank you so much, -Gabriele -- Gabriele Bartolini: Web Programmer, ht://Dig IWA/HWG Member, ht://Check maintainer Current