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

r 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@postgresql.org) To make ch

[PERFORM] Different location or different instance

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,

[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 ev

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

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: > Q

[PERFORM] Normal case or bad query plan?

_to)) Total runtime: 2780.359 ms Is this a normal case or should I worry? What am I missing? Do you have any suggestion 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://

Re: [PERFORM] Data warehousing requirements

rt needs) and transaction rate. Then try to estimate how much CPU and I/O they'll use. Thank you so much again Aaron. 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

[PERFORM] Data warehousing requirements

nd eventually replicated. Having 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