[SQL] [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them?

2003-08-28 Thread Marco Vezzoli
, in postgresql.conf, the value of max_fsm_pages and max_fsm_relations'. I didn't found any of these parameter in my postgresql.conf so I suppose that my version of postgresql is too old. Which versions supports these parameters? TIA Marco -- Marco Vezzoli tel. +39 039 603 68

Re: [SQL] postgres 7.1.3: why does the query plan ignore indexes?

2003-08-19 Thread Marco Vezzoli
[EMAIL PROTECTED] wrote: > > Marco Vezzoli <[EMAIL PROTECTED]> writes: > > ewsweb_test=> \d measures_product > > Index "measures_product" > > Attribute | Type > > +-- > > product_id | smallint >

[SQL] postgres 7.1.3: why does the query plan ignore indexes?

2003-08-19 Thread Marco Vezzoli
refer to leave the optimizer as clean as possible. Thanks in advence for any help. Marco -- Marco Vezzoli tel. +39 039 603 6852 STMicroelectronics fax. +39 039 603 5055 ---(end of broadcast)--- TIP 5: Have you checked our extensive FA

Re: [SQL] multiple index search with postgres7.1.3 on solaris 8

2003-06-12 Thread Marco Vezzoli
[EMAIL PROTECTED] wrote: > > On Thu, Jun 12, 2003 at 13:21:01 +0200, > Marco Vezzoli <[EMAIL PROTECTED]> wrote: > > Hi everybody, > > I'm sorry if this topic has already been explained, but the search > > engine at archives.postgresql.org shows me 10 pag

[SQL] multiple index search with postgres7.1.3 on solaris 8

2003-06-12 Thread Marco Vezzoli
the latter, according to EXPLAIN, uses the index the former doesn't. Why? Thanks in advance for any help, Marco -- Marco Vezzoli tel. +39 039 603 6852 STMicroelectronics fax. +39 039 603 5055 ---(end of broadcast)--- TIP 6: Have you se