Paul Thomas пишет:
> On 29/04/2004 09:53 Anton Nikiforov wrote:
>> looks like after a few tests that i've done i'm confused more than
>> I did create a table and inserted 200000 random records of two
>> different types of data into it.
> Did you analyze the table afterwards?
Hello and thanks for the comment. Yes. I did analyze.
Also thanks to Bruno Wolff III for his comments, i have found it easyear
to use his suggestion.
But while i was making my tests i found a way how to use partial or
complex indexes, but they make my selects slower than without indexes at
all :( (I was selecting * not a ma()). But i'll continue my tests.
In response to
pgsql-general by date
|Next:||From: Stefan Sturm||Date: 2004-04-29 12:55:21|
|Subject: Re: Postgre and Web Request|
|Previous:||From: Paul Thomas||Date: 2004-04-29 10:11:58|
|Subject: Re: Partial index question|