RE : [PERFORM] Large querie with several EXISTS which will be often runned

Hello Josh, > > I will have to manage more or less 10.000 products with > more or less > > 2-3 options by products and more or less 40 options-groups. > > > > Do you think that this query will be hard for PostgreSQL (currently > > 7.2.1 but I will migrate to 7.3.2 when going in production > >

Re: [PERFORM] Large querie with several EXISTS which will be often runned

On Saturday 28 June 2003 14:47, Bruno BAGUETTE wrote: > Do you mean this query ? > > SELECT > products_options_groups.pk_prdoptgrp_id,products_options_groups.prdoptgr > p_name > FROM products_options_groups > WHERE EXISTS > ( > SELECT * > FROM products_options_classification > INN

[PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf

I'm wondering how to speed up sorting which is slowing a query run regularly on a linux postgresql 7.3.3 system. The box is a dual PIII with 1Gb ram. The database is located on a 20Gb SCSI disk, with WAL on a separate disk. The only changes I've made to postgresql.conf so far are: shared_buffers=

Re: [PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf

On Saturday 28 June 2003 17:01, Chris Hutchinson wrote: > I'm wondering how to speed up sorting which is slowing a query run > regularly on a linux postgresql 7.3.3 system. > > The box is a dual PIII with 1Gb ram. The database is located on a 20Gb SCSI > disk, with WAL on a separate disk. > > The o

Re: [PERFORM] 'best practises' to speed up sorting? tuning postgresql.conf

> Chris Hutchinson wrote: > I'm wondering how to speed up sorting which is slowing a > query run regularly on a linux postgresql 7.3.3 system. I see a lot of seq scans in your explain and there are no index scans, have you done a 'vacuum analyze' lately? Arjen ---(end