Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: initdb in 8.3
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Christopher Condit" <condit(at)sdsc(dot)edu>
- Cc: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
- Subject: Re: initdb in 8.3
- Date: Thu, 24 Apr 2008 10:02:16 -0400
- Message-id: <27854(dot)1209045736(at)sss(dot)pgh(dot)pa(dot)us>
"Christopher Condit" <condit(at)sdsc(dot)edu> writes: > Although, once you've built the index with varchar_pattern_ops index, > the following two (essentially equivalent) queries will run at vastly > different speeds: > select * from A where A.value like 'Nacho'; > select * from A where A.value = 'Nacho'; > Seems that the optimizer should catch this... Yeah, it's on the to-do list ... http://archives.postgresql.org/pgsql-hackers/2008-02/msg01003.php regards, tom lane
- References:
- initdb in 8.3
- From: Tim Tassonis
- Re: initdb in 8.3
- From: Peter Eisentraut
- Re: initdb in 8.3
- From: Tim Tassonis
- Re: initdb in 8.3
- From: Martijn van Oosterhout
- Re: initdb in 8.3
- From: Tim Tassonis
- Re: initdb in 8.3
- From: Christopher Condit
- Re: initdb in 8.3
- From: Craig Ringer
- Re: initdb in 8.3
- From: Christopher Condit
- initdb in 8.3
- Prev by Date: Re: initdb in 8.3
- Next by Date: Re: Best backup setup
- Previous by thread: Re: initdb in 8.3
- Next by thread: Re: initdb in 8.3
- Indexes: