WireSpot wrote:
On Wed, 02 Feb 2005 14:48:41 +, Richard Huxton wrote:
Think about it, you'd need an index that ordered use_name so that
(john_doe, Ajohn_doe, Zjohn_doe1234) were all next to each other.
If you anchor the search (LIKE 'john_doe%') and are using the C locale
then an index can
On Wed, 02 Feb 2005 14:48:41 +, Richard Huxton wrote:
> Think about it, you'd need an index that ordered use_name so that
> (john_doe, Ajohn_doe, Zjohn_doe1234) were all next to each other.
>
> If you anchor the search (LIKE 'john_doe%') and are using the C locale
> then an index can be u
WireSpot wrote:
I have a table with about 200.000 entries. Among other things, it
contains an integer field I use as a timestamp, and a variable
character field I use for user names. Certain queries are taking too
long IMO. I'm trying this on both 7.4 and 8.0.
If I do a direct comparison (using
I have a table with about 200.000 entries. Among other things, it
contains an integer field I use as a timestamp, and a variable
character field I use for user names. Certain queries are taking too
long IMO. I'm trying this on both 7.4 and 8.0.
If I do a direct comparison (using =) on the user nam
On Mon, Dec 11, 2000 at 05:09:40PM -0300, Martin A. Marques wrote:
> On Monday 11 December 2000 15:56, Juriy Goloveshkin wrote:
> > is it posible to shop query time in psql frontend?
> What do you mean with: shop query time?
oops... s/shop/show/
I want to know how many time the query executed. lik
On Monday 11 December 2000 15:56, Juriy Goloveshkin wrote:
> is it posible to shop query time in psql frontend?
What do you mean with: shop query time?
--
System Administration: It's a dirty job,
but someone told I had to do it.
is it posible to shop query time in psql frontend?
(like in mysql)
--
Bye
Juriy Goloveshkin
