Postgres Pro
Downloads
Home   >   mailing lists

Thread: PErformance in tables to large

PErformance in tables to large

From
Date:
Hi all,

I have a table with 3,000,000 of rows, I have two index:
idx1 on --> (f_name,s_name,f_lastname,s_lastname)
idx1 on --> (f_name,f_lastname)

if the query is on 4 columns of the idx1, the result is speed, but if teh
query is on  two columns of the idx2 the rsult take 10 minutes.

My postmaster run with option -S -o -F for best performance, but the
results is very slow.

I need suggestions, Thanks in advance,

Regards,
"La Vida"

Re: PErformance in tables to large

From
Stephan Szabo
Date:
Have you done a vacuum analyze on the tables, what are the
queries you're running and what does the explain output
from them look like?

Stephan Szabo
sszabo@bigpanda.com

On Tue, 26 Sep 2000 vlal@ideay.net.ni wrote:

> Hi all,
>
> I have a table with 3,000,000 of rows, I have two index:
> idx1 on --> (f_name,s_name,f_lastname,s_lastname)
> idx1 on --> (f_name,f_lastname)
>
> if the query is on 4 columns of the idx1, the result is speed, but if teh
> query is on  two columns of the idx2 the rsult take 10 minutes.
>
> My postmaster run with option -S -o -F for best performance, but the
> results is very slow.
>
> I need suggestions, Thanks in advance,
>
> Regards,
> "La Vida"
>

security , multiple interface

From
Loïc TREGOUËT
Date:
                                    Hello ,

    I've on my server 3 interfaces :
- lo (127.0.0.1)
-eth0  ( xxx.xxx.xxx.xxx)
- eth0:1 (alias 192.168.xxx.xxx)


Is it possible to listen  (bind ?) only lo and eth0:1 and not eth0 for
PostgreSQL? ( with a PostgreSQL configuration)

I'm french , i hope all my words will be understood ....


                                                        loic@cri74.org