[PERFORM] Storing data and indexes in different disks

Hi, I'm about to recommend a server model to a client, and I've read a in many places (including in this list) that storing indexes in one disk and the rest of the database in other disk might increase the overall performance of the system in about 10%. Making this only by a symbolic link

[PERFORM] RAID Configuration Sugestion

Hello, We are about to install a new PostgreSQL server, and despite of being a very humble configuration compared to the ones we see in the list, it's the biggest one we've got till now. The server is a Dual Xeon 3.0 with 2 GB RAM and two SCSI disks. Our main doubt is what is the best config

[PERFORM] Hardware upgraded but performance still ain't good enough

Hi, First of all I must tell that my reality in a southern brazilian city is way different than what we read in the list. I was lookig for ways to find the HW bottleneck and saw a configuration like: "we recently upgraded our dual Xeon Dell to a brand new Sun v40z with 4 opterons, 16GB of me

[PERFORM] Performance difference when using views

(cost=0.00..164.94 rows=9694 width=23) -> Hash (cost=1.27..1.27 rows=27 width=10) -> Seq Scan on state u (cost=0.00..1.27 rows=27 width=10) (18 records) Best regards, -- +---+ | Alvaro Nunes MeloAtua Sistemas de Informacao | | [

[PERFORM] Better Hardware, worst Results

otal used free sharedbuffers cached Mem: 439434 4 0 16 395 -- +-------+ | Alvaro Nunes MeloAtua Sistemas de Informacao | | [EMAIL PROTECTED]www.atua.com.br | |UIN

Re: [PERFORM] Better Hardware, worst Results

pped explains. In our brazilian PostgreSQL mailing list, attachments are not allowed, so I send them as inline text. Thanks to everyone who spent some time to help me solving this problem. -- +-------+ | Alvaro Nunes MeloAtua Sistemas de Info

[PERFORM] Normalization or Performance

ove uses indexes for queries, etc. But even with this it's not been fast enough. We have a Dell server for this (I know, the Dell issue), a Dual Xeon 2.8, SCSI HD, 1 GB mem. Do we need better hardware for our system? -- +-----------+ | Alvaro Nunes

[PERFORM] Very different index usage on similar tables

in dex in the telephone table is multicolumn, I'd tried to drop it and create a single-column index, but the results were quite the same. Thanks, -- +-------+ | Alvaro Nunes MeloAtua Sistemas de Informacao | | [EMAIL PROTECTED]

Re: [PERFORM] Similar tables, different indexes performance

Em Seg, 2004-12-13 às 16:03, Bruno Wolff III escreveu: > On Mon, Dec 13, 2004 at 15:17:49 -0200, > Alvaro Nunes Melo <[EMAIL PROTECTED]> wrote: > > db=> SELECT COUNT(*) FROM titulo WHERE cd_pessoa = 1; > > count > > --- > >220 > > (1 rec