Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: select on 1milion register = 6s
- From: Hervé Piedvache <bill(dot)footcow(at)gmail(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Cc: "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>
- Subject: Re: select on 1milion register = 6s
- Date: Sat, 28 Jul 2007 21:56:58 +0200
Do you have analyzed your table before doing this ? Le samedi 28 juillet 2007, Bruno Rodrigues Siqueira a écrit : > Friends, > > > > > > > > Who can help me? My SELECT in a base with 1 milion register, > using expression index = 6seconds. > > > > > > Please, I don't know how to makes it better. > > > > > > Thanks -- Hervé Piedvache
- Follow-Ups:
- RES: select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- RES: select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- RES: select on 1milion register = 6s
- References:
- select on 1milion register = 6s
- From: Bruno Rodrigues Siqueira
- select on 1milion register = 6s
- Prev by Date: Re: select on 1milion register = 6s
- Next by Date: Re: Slow query with backwards index scan
- Previous by thread: Re: select on 1milion register = 6s
- Next by thread: RES: select on 1milion register = 6s
- Indexes: